AD 2000-25-02 R1
Registered aircraft · 7,560
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:2000-25-02-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:2000-25-02-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:2000-25-02-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:2000-25-02-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.
N124SCK2 Worldwide Inc · Simi Valley, CAN124SGFull Props LLC · Ridgeland, SCN124WDKcsi Aerial Patrol Inc · Bakersfield, CAN1251EVan Dun Egidius J · Green Cove Springs, FLN1254EMiller James L · Galena, ILN1255EReed Gretchen M · Madison, OHN1258ECadd Jonathan A · Newberg, ORN125CMKuester Austin · Oshkosh, WIN125RSAlexander William F · Chapmansboro, TNN125WB90er LLC · Wilmington, DEN1267EJohnson Donald W · Sharpsburg, GAN1267TTroxel Jeffrey L · Menomonee Falls, WIN1268EBlocker Steve J · Edgar Springs, MON126WBFlying Blank LLC · La Crosse, WIN1270ESteiner Zachary J · Bethlehem, CTN1278EBradley Christopher · Juneau, AKN127BDRegistered aircraftN127SAVintage Tailwheel LLC · Wilmington, DEN127TMPlane Air LLC · Paducah, KYN1281EGlanz William L · Central, AKN1282EMolek Eugene · Warren, OHN1286EWilson Stuart L · Glenpool, OKN128DMTransnovia LLC · Haslett, MIN128SMHafford Jay T · Stevenson, WAN128VMThomas Lucas G · Beebe, ARN1292HHall James E · Naples, FLN1294ESouthwind Aviation Inc · Maryville, TNN1296EBigger William · Partlow, VAN12DFGagne Gilbert R · Apple Valley, CAN12KDDeeble Kenneth M · Dayton, MTN12PNRegistration Pending · Maitland, MORegistration pendingN12TLLoofbourrow Travis S · Houston, TXN12TNEgret Aero Inc · Colorado Springs, CON1300EHager David L · Barney, NDN1302EVitiello Anthony J · Ballwin, MON1303EGregory James A · East Burke, VTN130ACBilco Air LLC · Danville, ILN130VUSwords Kyle · New Albany, MSN1310EEaglet Flight Operations Lp · Fort Worth, TXN1313EKokes Joseph A · Greenwood, INN1316VKaufman Keith R · Reading, PAN131DWWeitz David M · Caldwell, IDN131GSStanley Gerald L · Littleton, CON131PMDodge Sean · Littleton, NHN131RAFlorida Institute Of Technology · Melbourne, FLN131RCNordman Clay DBA · Catheys Valley, CAN131RHZollars Thomas Brooke · Dallas, TXN131SEHouseman Steven · Chillicothe, OHN131SGPrewitt Thomas R · Hope Mills, NCN1321EMiller Mark A · Waldoboro, ME
Back to AD 2000-25-02 R1