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.
N44CYMiskell Christopher S · Senoia, GAN44CZHeer James A · Lutz, FLN44DADuncan Aviation Inc · Lincoln, NEN44DBSperr David F · Rock Hill, SCN44DGTime Flies LLC · Fort Worth, TXN44DMGorge Winds Aviation Inc · Fairview, ORN44DPD L S Aviation Inc · Wilmington, DEFirst renewal noticeN44DQTumbleweed Leasing Co Inc · Salt Lake City, UTN44DRFiretextresponse LLC · Sumner, ILN44DWGrumman Widgeon LLC · Missoula, MTN44DZWanted Poster Owners Group LLC · York, PAN44ECN44ec LLC · Caddo Mills, TXN44EEEchemann Thomas A · Sidney, OHN44EKBas Part Sales LLC · Greeley, CON44EWPlane Fun Inc Tr Trustee · Snellville, GAN44FATemple Craig A · Fort Lauderdale, FLN44FDHildreth David M · Kennesaw, GAN44FGSaratoga Helicopter LLC · Queensbury, NYN44FSJinsky Ronald G · Beloit, WIN44GAFly Qts LLC · Oconomowoc, WIN44GDCarver Michael A · Ocala, FLN44GNMitchell Martin B · Newport Beach, CAN44GZOpdahl Kirk J · Lees Summit, MON44HALaps LLC · Elkhorn, WIN44HDAir Assault Agricultural Aviation LLC · New Castle, VAN44HGHigher Ground Helicopters Of Cincinnati LLC · Miamisburg, OHN44HKBradt Joseph J · Inver Grove, MNN44HNCedar Ridge Aviation LLC · Knox City, TXN44HRCardinal Aviation Services LLC · Castle Rock, CON44HUFritsche James G · Greenleaf, WIN44HVMarinella Steve · Chandler, AZN44HYCochran Thomas S · Fort Collins, CON44JAJersey Aero Club Inc · Lakewood, NJN44JFEureka E Solutions Inc · Austin, TXN44JGLiberty Industries LLC · Washington, DCN44JKKirkman Todd · Chetek, WIN44JLBushcat Goldie LLC · Oro Valley, AZN44JRRodgers Jerry T · Bishop, CAN44JUEcho Mike Consulting LLC · Wilmington, DEN44KCSpitfire Ix Inc · Wilmington, DENon-citizen corporation, flight hours not reportedN44KDSale Reported · Crystal, MNSale reported, canceledN44KFEbert Construction Co Inc · Wamego, KSN44KGSpanogle Michael M · Chugiak, AKN44KLStell Brandon A · Mechanicsville, VAN44KPHargrave Margarite D · Seattle, WAN44KRMcilhenny Edward A · Clayton, GAN44KVHughes Eugene F Jr · Butte, MTN44KYBas Part Sales LLC · Greeley, CON44LETp Aviation LLC · Redding, CAN44LKCessna Skyhawk LLC · Parker, COFirst renewal notice
Back to AD 2007-04-19 R1