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.
N545SFCrabtree William D · Big Lake, AKN545SMWood Kyle Aubrey · Soldotna, AKN545TYoung Trinity D · Mena, ARN545UCatching Freedom LLC · Bozeman, MTN545VSouthern Aircraft Consultancy Inc Trustee · Casper, WYN545WKenmore Crew Leasing Inc Trustee · Bellingham, WAN545WAStine Scott A · Vincennes, INN545WHBledsoe Bobby H · Hot Springs, ARN545WRCumulus Aviation Services LLC · Port Orange, FLN545WWGrisham Michael H · Paulden, AZN545YCatching Freedom LLC · Bozeman, MTN545ZDornoch Services LLC · Dover, DEN5460NWylie David · Sharon Springs, NYN5460PT & C R Wing'N It LLC · Tempe, AZN5460UMall Eugene R · Cairo, NYN5461Lb Flying Aces LLC · Wilmington, DEN5461AYaeger Edwin R · Stoneville, NCN5461DCenter For Endodontics Inc · Fresno, CAN5461JGlyn Dwr Aviation LLC · Kalispell, MTN5461KFaragallah Allan A · Garden Grove, CAN5461LClinton Lance D · Lago Vista, TXN5461PGraham Truett A · Lubbock, TXN5461RRegistered aircraftN5461SCarter Kenneth M Jr · Castle Rock, CON5461WGarvey David G · Erie, PAN5461XState Of Alaska · Anchorage, AKN54626Continental Title Trust LLC Trustee · Wichita, KSN54628Ohio State University · Columbus, OHN5462LGilbert Jason J · Oakland, MEN5462QLeading Edge Flight Academy LLC · Bend, ORN5462THebert David · Lafayette, LAN5462XThomas Jackson Smitih · Baton Rouge, LAN54633Warner Walter M · Willow, AKN54634Savannah Airplane Venture LLC · Myrtle Beach, SCN54635Memphis Navy Flying Club · Millington, TNN5463DBlanco Austin · Newcastle, CAN5463JMachado Joe L · Tucson, AZN5463KRick Aviation Inc · Newport News, VAN5463LMcpherson Allen G · Batesville, INN5463NM Sipolt Air LLC · Paradise Valley, AZN5463WAngels Envy Aviation LLC · Denison, TXN5464Larson Margaret June · Shelbyville, TNN54646Jordao Isabella C · Oklaunion, TXN5464DJprg Aviation Inc · Orlando, FLN5464KTrend Vector Aviation International Inc · Barrigada, GUN5464LKelly Michael J · American Fork, UTFirst renewal noticeN5464VLivingood Richard A · Tucson, AZN5465DPatten Sarah F · Catlett, VAN5465KMonroe Pilots Association LLC · Monroe, NCN5465NRing Niel W · Buhl, ID
Back to AD 2007-04-19 R1