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.
N3131ZPralle Jeffory K · Wasilla, AKN3132CBlack Eric · Fort Jones, CAN3132FN3132f LLC · Metairie, LAN3132PSarratt Curtis H · Annapolis, MDN3132TUballe Ruben · Axtell, TXN3132WSteve Rodemer Esq LLC · Colorado Springs, CON3132YLampkin George G · Forney, TXN3133PLumley John J · Delray Beach, FLFirst renewal noticeN3133QLearn 2 Fly Ct LLC · Simsbury, CTN3133RSprott James D · Harrison, ARN3133SMitchell Terry R · Tallahassee, FLN3133TGiddy Up Aviation LLC · Ada, OKN3134DHanson Parry B · Eagle Creek, ORN3134LTrax Eric E · Vero Beach, FLN3134PSchmidt Casey D · Cedar Rapids, IAN3134UBaine Larry A · Marne, MIN3134WDans Flying Service Inc · Crookston, MNN3135CVeech Shawn M · Big Lake, AKN3135DSkycavu Inc · Hi Rls Mtn Pk, NMNon-citizen corporation, flight hours not reportedN3135EHerring Christopher E · Granbury, TXN3135GDrake Michael L · Bellevue, WAN3135LTempelhof Aviation · Las Vegas, NVN3135QGrf Aviation LLC · Destin, FLN3135RSerna Alvaro V · San Antonio, TXN3135ULogue Christopher A · Trout Run, PAN3135WFlycarolina LLC · Concord, NCN31368Anderson Aviation Inc · Anderson, SCN3136CPark Avenue Group Inc · Stuart, FLN3136FMurdock Lloyd W · Princeton, KYN3136QN3136q Flyers LLC · Las Vegas, NVN3136RKuntz Trucking Co · Gridley, ILN3136SSeiler Richard D · Bozeman, MTN3136XBobbett Robert Todd · West Richland, WAN3136YReed Jason B · Faith, SDN3136ZSchafer Patrick A · Marietta, OHN31377Piercy Brian A · Kalispell, MTN3137CKlausler Thomas W · Lakeville, MNN3137ERegistered aircraftN3137FJbm Endeavors LLC · Chewalah, WAN3137RGriffith Moseley Johnson & Associates Inc · Port Arthur, TXN3137SManley Robert E · Ferndale, WAN3137UCurson Randy J · Cape Coral, FLN3137YLopez Juan F Jr · Del Rio, TXN31380Aldred John B · Washoe Valley, NVN31385Registration Pending · Missoula, MTRegistration pendingN31388Sisk Farms LLC · Hopkinsville, KYN3138CTurbo-Sphere Inc · Longmont, CON3138QShepard Donald · Lake Havasu City, AZN3138R15 Rides LLC · Manteo, NCN3138TJones Daniel D · Ekron, KY
Back to AD 2007-04-19 R1