AD 2007-24-13
Registered aircraft · 4,026
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-24-13')
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-24-13')
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-24-13') 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-24-13') 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.
N66PE811wm LLC · Watertown, CTN66VMPg Air LLC · Bellbrook, OHN670DSSongbird Leasing LLC · Nashville, TNN670PCw Veach Logistics LLC · Allerton, IAN671CDCirrus Design Corp · Duluth, MNN671JLJgl Aviation LLC · Boca Raton, FLN672CDRegistered aircraftN673CDR58 Aviate LLC · Granbury, TXN673RVMev Aviation LLC · Fort Lauderdale, FLN673SRHarrison Terry W · Soldotna, AKN674CDEagle Air US Inc · Eau Claire, WIN674KYMorning Star Aviation LLC · Houston, TXN675ATRegistered aircraftN675CBWe B Flyers Ltd · Wilmington, DEN675NMiller Michael G · Jersey City, NJN675PSCl Max Inc · Wilmington, DEN675SPPlane Fun Aviation LLC · Bradenton, FLN675SRCirrus Sr22 2776 Inc Trustee · Wilmington, DEN675WHayes Richard J · New Smyrna Beach, FLN677CDInternational Air Services Inc Trustee · Carson City, NVN677CPSweet Spot Consulting LLC · Fort Myers, FLN677MBChaves Carlos A · San Juan, PRFirst renewal noticeN677MDSt Pete Aviators LLC · St Petersburg, FLN678BWElem Enterprises LLC · Wilmington, DEN678CDFrogman Flight Ops LLC · Wilmington, DEN678DADiscovery Aviation Inc · Discovery Bay, CAN678DFForney Dylan · Murchison, TXN678ECCavu Holdings LLC · Greensboro, GAN678GWAtterrissage LLC · Healdsburg, CAN678PCComplete Rv LLC · Kalispell, MTN678SRDc Air LLC · Dover, DEN678ZBas Part Sales LLC · Greeley, CON679CDHsc Aviation LLC · Gig Harbor, WAN679LMLone Mountain Aircraft LLC · Vandalia, OHN67AMR&R 22t1 LLC · Wilmington, DEN67DPCirrus Sr22 2933 Inc Trustee · Wilmington, DEN67MZMain Flyer LLC · Fort Lauderdale, FLN67SAE And J Medical Consulting LLC · Lima, OHN67TZKac Air LLC · Rindge, NHN68007N68007 LLC · Stratford, CTN680PBoren John D · Martinsville, INN681CWalker Jabir Salim · Louisville, KYN681CDSwift Bruce I · Ambler, PAN681MBBerger James B · Warrenton, VAN681PGRspd-Air LLC · High Point, NCN681SRegistered aircraftN682CDFly Tlc LLC · Dexter, MON682RMHuebel Ross · Houston, TXN682SRMajdalani Maher J · Perrysburg, OHN6830WRocket Airways LLC · Verona, WI
Back to AD 2007-24-13