AD 94-05-05 R1
Registered aircraft · 26,232
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N6267TLittleton Roy T III · Ruther Glen, VAN6268EBilton Nicholas J · Bozeman, MTN6268SHayes Barrett W · Siler City, NCN6268TBartkowiak Alex M · Moorhead, MNN6269ERule Paul Crane Trustee · Wapato, WAN6269GMattingly Andrew R · New Albany, INN626AD2 Shotz LLC · Ashland, VAN626EJHartle Gary G · Greencastle, PAN6270SHudson Kelly G · Monroe, NCN6271ENate Abel Flying Club · Fort Worth, TXN6271GSumpter Kenneth W · Enid, OKN6271SJay Square Aircraft Inc · Hilton Head Island, SCN6271TBesteiro Aly E · Brownsville, TXN6272EFeauto Aviation Inc · Saint Cloud, FLN6272GDunn Michael Thomas · Arlington, VAN6273EBunner Corin Anthony · Murfreesboro, TNN6273HWilkinson Dane W · Morgan, UTN6274EHuff Air LLC · Uvalde, TXN6277SJones Joseph L · Saint David, AZN6277TMaier Daniel Edward · Vancouver, WAN6278EJ K Sparks Inc · Lutz, FLN6279TCragg Gordon E · Georgetown, TXN627MHappy Kamper Aviation LLC · Austin, TXN627PTAllen Thomas R · Vacaville, CAN6281EPlunk Ben · Mesquite, TXN6281TSalyer Arthur W · Temecula, CAN6282KLowder Harold E · Fresno, CAFirst renewal noticeN6282SWorth William D · Huntington Beach, CAN6283CBaker Mike D · Benton, KSN6283RAkchak Air LLC · Leeds, UTN6283SMorris Kristina T · Ventura, CAN6284CYardley & Co Inc · Quinn, SDN6284ECastle Donald L · Auburn, CAN62853Willkomm John C · Kenosha, WIN6285CMiel Jerry A Trustee · Green Valley, AZN6285SWindsor John R · East New Market, MDN6285TReasner David S · Moultonborough, NHN6286CHubbard Mark A · Wilmington, DEN6286SCunningham Doris DBA · East Freetown, MAN6287EClemons Martin · Butte, MTN6287GPeters Guy P · Roy, UTN6287KWilliams Jimmy Z · Sherman, TXN6288EMccardy Derk · Torrance, CAN6288GFetter Stanley B · Accokeek, MDN6288KCentral Virginia Aviation Inc · North Dinwiddie, VAN6288TGrote Bradley J · Torrington, WYN6289EMaverick Jets LLC · Vineburg, CAN6289KPitcock Randall · Farwell, TXN6289SLink Darryl B · Centennial, CON628MAFitzgerald Brian B · Gettysburg, PA
Back to AD 94-05-05 R1