AD 73-26-07 R3
Registered aircraft · 567
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:73-26-07-R3')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:73-26-07-R3')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:73-26-07-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:73-26-07-R3') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N441TNPure Aviation Leasing LLC · Las Vegas, NVN441VTraveling Alana Inc · Key Largo, FLN441VHWe Fly LLC · Fort Payne, ALN441WLVichy Enterprises LLC · Wilmington, DEN441WTHaven Air LLC · Winter Garden, FLN444WDFlyto LLC · Indianapolis, INN445DFUsda Forest Service Fepp · Mcclellan, CAN448CASouthern Aircraft Consultancy Inc Trustee · Casper, WYN4490MIndian Ink Leasing Inc · Amarillo, TXN449BKMu2b40 LLC · Rancho Santa Fe, CAN44AFTrinity Group · Watford City, NDN44MXRiver City Aviation Inc · Fairdealing, MON450DFUsda Forest Service Fepp · Mcclellan, CAN456GTConquest 294 LLC · Wilmington, DEN459SASolitaire Leasing LLC · Evanston, ILN461MAGood Aviation LLC · Oshkosh, WIN462MARegistered aircraftN466DCAerotel Inc · Spring Hill, FLN466SMMiddleton Lee Sam · Lubbock, TXN467MAAlc Aviation LLC · Cheyenne, WYN46AKExpress Aviation Management LLC · Dover, DEN46HLGsp Air LLC · Sparta, NJN46LHSkyventure Arizona LLC · Reno, NVN470SGGeneral Atomics Aeronautical Systems Inc · Poway, CAN479SGGeneral Atomics Aeronautical Systems Inc · Poway, CAN47EPRum Bum Distributors Inc · Miami, FLN47ZGJep Air LLC · Jackson, WYN480SGGeneral Atomics - Aeronautical Systems Inc · Poway, CAN483AFAir 1st Aviation Companies Inc · Aiken, SCN485AFLaver Michael · Glendale, AZN486MTNavy 8686 LLC · Boston, MAN487AFAir 1st Aviation Companies Inc · Tyndall Afb, FLN487UEAircraft Propulsion Leasing LLC · Holland, OHN489AFLaver Michael · Glendale, AZN48NPJere Aviation LLC · Fond Du Lac, WIN496PTPlane Folk LLC · Klamath Falls, ORN4NEP M Leasing Inc · Perris, CAN4RRough Ryder Aircraft Inc · Carmel, NYN4WDHat Creek Aviation LLC · Hamilton, MTN500ERConquest II LLC · Kenner, LAN500PJFly2mellc · Ooltewah, TNN5016HBest Aircraft Deals LLC · Salt Lake City, UTN502AKProvost Michael A · Jefferson, GAN502BRUS Leasing And Financial Inc · Wilmington, DEN502VAInternational Bank Of Commerce · Laredo, TXN505GMNc Hold 7 LLC · Raleigh, NCN507ZZAce Aviation LLC · Mankato, MNN508FACbg LLC · Wilsonville, ORN508PMTvc Av LLC · Jacksonville, FLN50DAP M Leasing Inc · Perris, CA
Back to AD 73-26-07 R3