AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
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:2007-04-19-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') 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.
N34927Brown Donald M · Eastsound, WAN34929Geister Ryan · Alto, MIN3492QLadet William D · Las Vegas, NVN3492TBell Anthony J · Avondale, AZN3492UMaligator Air LLC · Missoula, MTN3492WMyers Andrew John · Wadsworth, OHN3492XMckay Christopher L · Point Arena, CAN3492ZMusgrove Jimmy Wayne · Delta Junction, AKN34931Moyer David R · Souderton, PAN34934Rider Nelson F · Ulysses, KSN3493APapago Equipment LLC · Bayfield, CON3493RValente Joseph · Sun Lakes, AZN3493SCola William Patrick · Colfax, CAN3493WVerser James A · Greers Ferry, ARN3493XKnepper Gary E · Canby, ORN34941Mosley Timothy D DBA · Calhoun, KYN34943Cardco Aviation LLC · Wilmington, DEN3494AWheeler Michael R · Peculiar, MON3494BLiguori Fred C · Granby, CTN3494FParadise Aviation LLC · Shoreline, WAN3494NCox Eric L · Sheridan, WYN3494QRodcon Aircraft Sales LLC · Kalispell, MTN3494SLadder Livestock Company LLC · Savery, WYN3494WHarrison Brett A · Fishers, INN3494XQuantum Returns Club LLC · Southampton, NYN34959Scales Richard O · Signal Mountain, TNN3495LSaqul'Aq Air LLC · Coupeville, WAN3495RC182 Flyers LLC · Las Cruces, NMN3495S3495s LLC · Prescott, AZN3495ZDillon Edward L · Anchorage, AKN34964Rayle John R · Aurora, OHN34966Williams John D · Geneva, OHN34967Brady Francis T · Meridian, IDN3496AM-1 Medical LLC · Fairview Heights, ILN3496TSchwenk Franklin · Ben Wheeler, TXN3496YPincus Howard E · Grass Valley, CAN34973Spear Aviation LLC · East China, MIN34976Mungenast Andrew J Jr · Lancaster, TXN34977Holtzman Gary E · Van Alstyne, TXN34979Bouvier Richard · Bristol, CTN3497PKitchens Craig N · Salt Lake City, UTN3497RWhitfield Derwin C · Picayune, MSN3497SHenry Bruce N · Bloomfield, NMN3497TSeth Stephen L · Lake Jackson, TXN3497WRobb Kirk C · Abingdon, ILN3497XLawson Alan K · Kirbyville, MON3497YBraden John C · Anchorage, AKN34980Augestad Robert D · Marietta, GAN34981Scales Richard · Signal Mountain, TNN34982Gingerich Mark J · Morton, IL
Back to AD 2007-04-19 R1