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.
N310EWAerial Imaging Inc · South Bend, INN310FADenning Lawrence I · Liberty, MON310FCScott Jed L · Salem, VAN310FFHangar 28 Aviation Holdings I LLC · Cody, WYN310FGMcalpine David B · Fort Worth, TXN310FJSimmonds Don M · Sandpoint, IDN310FPMorley Thomas O · Riverside, CAN310FSModi Yogini · Homestead, FLN310GCCook Kevin M · Missouri City, TXN310GGSale Reported · ObersulmSale reportedN310GJRocket City Aero LLC · Huntsville, ALN310GQMayo Ray C Jr · Shreveport, LAN310GRDailey Jordan · Umatilla, FLN310GSKnot So Fast Aviation Inc · Kernersville, NCN310HBSmith William G · Huntsville, TXN310HCGlover David D · Pittsburgh, PAN310HDWwdd Enterprises LLC · Port Orange, FLN310HMInternational Air Services Inc Trustee · Carson City, NVN310HSValiair Lc Trustee · Casper, WYN310JNgugi Samson W · El Paso, TXN310JBBickel Aviation LLC · Wilmington, DEN310JDPritchett Jerry D · Lakeville, MNN310JGMarc Inc · Bolton, MSN310JNAustin Baumgarten Inc · Tomah, WIFirst renewal noticeN310JPBrock Kyle · Riverdale, CAN310JTCowan David E · Mount Pleasant, SCN310JWWharton Melissa P · Wise, VAN310KBSchulte Delmar L · Cottonwood, CAN310KCMattix Charles B · Temple, TXN310KDEmerald City Aircraft Leasing Inc · Port Orchard, WAN310KMStitt Consulting Inc · Titusville, FLN310KTSmith Gregory E · White Lake, MIN310LAPorter Kenneth M · Cottonwood, AZN310LBTradewind Aviation Management LLC · Oxford, GAN310LDAbq 421 LLC · Albuquerque, NMN310LEJones Kent D · St George, UTN310LGCccp LLC · Mustang, OKN310LMMoore Alton · Lago Vista, TXN310LPIsaacs W Bradford · Las Vegas, NVN310LRCasavia Corp · Guelph OntarioN310LTCarrer Aviation LLC · Coshocton, OHN310LWMy Way Aviation LLC · Weston, FLN310MAustin Security Inc · Battleboro, NCN310MAMbm Leasing LLC · Saint Louis, MON310MBSouthern Aircraft Consultancy Inc Trustee · Casper, WYN310MCEcolift Corp · San Juan, PRN310MDPbh Investments LLC · Wichita, KSN310MFCurran William A III · Opelika, ALN310MGGoroff Marc · Livermore, CAN310MHLawrence Jack C Jr · Saint Augustine, FL
Back to AD 2007-04-19 R1