AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
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:2006-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') 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.
N177RCChase Bruce R · New Albany, PAN177RDMoulton Diana L · Pine Mountain Club, CAN177RWDg Aviation LLC · Avon, INN177SHAdams Richard D · Kalamazoo, MIN177SMFree State Flying Club Inc · College Park, MDN177SRTumbleweed Leasing Co Inc · Salt Lake City, UTN177SVDlg Aviation LLC · Lena, WIN177TJCobb Joseph Jr · Medina, OHN177TSAero Cardinalis Inc · Midlothian, TXN177VTSeelig Richard W · Amherst, MAN177WCDittmer William R · Wheatland, NDN177WMFarley Glen · Marysville, OHN177XCColeman Timothy R · Morgantown, KYN177XSWilson Kent M · Roanoke, VAN1780Nelson Kevin T · Corvallis, ORN1781RDale Mar Enterprises Inc · Granton, WIN1781TFlight Operations Aircraft LLC · Wilmington, DEN1782TFlight Operations Aircraft LLC · Wilmington, DEN1786RWhalen Dann Trustee · San Diego, CAN1787DKissel Patrick J · Anchorage, AKN1788TFlight Operations Aircraft LLC · Wilmington, DEN178AFSoutheast Aircraft Leasing LLC · Jacksonville, FLN178ARPiper Aircraft Inc · Vero Beach, FLN178BCAllen Lisa M · Melba, IDN178BDMiltimore Jeffry D · Newark, OHN178CPCivil Air Patrol · Maxwell Afb, ALN178DKSchenck James R Trustee · Mclean, VAN178DMMukherjee Sanjoy · Flemington, NJN178DRH&H Trucking Inc · Clarkdale, AZN178GPanhandle Groundwater Conservation District · White Deer, TXN178GWBravo Aircraft LLC · Ooltewah, TNN178MSouth Texas Weather Modification Association · Pleasanton, TXN178MAMayes Richard A · Bend, ORN178MCWillett Cattle Co · Sanford, CON178TTLockwood Kurt G · Fairbanks, AKN17915US Aviation Training Solutions (Usats) · Titusville, FLN179AMNorth American Flight Services Inc · Ballston Spa, NYN179BCDenmark Ag · Winters, CAN179BWAshmore Lance E · Rogers, ARN179DHicks Jonathan · Edgewood, TXN179ECKibler Inc · Wilmington, DEN179GCWolfpacc Inc · Ponte Vedra, FLN179GTNeedham Charles Scott · Washington, UTN179JSMcdonald Timothy Steven · Slaton, TXN179MAAir-Knechtions LLC · Batavia, ILN179MEFlight Rt LLC · Thonotosassa, FLN179NDUnd Aerospace Foundation · Grand Forks, NDN179PCMsb Aero LLC · Middletown, DEN179RMRaven Air LLC · Coral Gables, FLN17ACPressley Brent DBA · Morristown, TN
Back to AD 2006-10-21