AD 2012-17-05
Registered aircraft · 1,197
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:2012-17-05')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-17-05')
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:2012-17-05') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-17-05') 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.
N200WKSkyview LLC · Wilmington, DEN201LSOcean Outlook Aviation LLC · Dover, DEN202AVAvista Corp · Spokane, WAN202JKRosado Aviation Inc · Moosic, PAN202LGLegacy 20 Enterprises LLC · Wilmington, DEN202WRDumont Associates Inc · Morris Plains, NJN2033Aircraft Holding Solutions LLC Trustee · Newark, DEN204RTCalifornia Motorsports Group Inc · San Diego, CAN209CQFalcon 900ex Msn 98 LLC · New Castle, DEN209HPEdison Acquisitions LLC · Chesterfield, MON20CRWestern Air International Corp · Fort Lauderdale, FLN20GJGlobal Jetcare Inc · Brooksville, FLN20GPN83 Charlie Inc · Fort Wayne, INN20GXWide Open Skies Viii LLC · Belgrade, MTN20PJAviation Trust Company LLC Trustee · Oklahoma City, OKN211ECEast Coast Flight Services Inc · Easton, MDN211GSInternational Air Services Inc Trustee · Carson City, NVN212AGSea Aviation Holdings LLC · Wilmington, DEN212XXLegacy Aviation Trust Holdings Corp · Edmond, OKN213RGGlobal Avionics LLC · Downey, CAN214TDHarbor Aircraft LLC · Wilmington, DEN217MJMtk Leasing LLC · Woodburn, ORN217PTVapor Air LLC · Camden, DEN218PJSoany Steam Inc · Cheyenne, WYN218RXAviation Resource Group Inc · Fort Lauderdale, FLN21HMIheartmedia Management Services Inc · New York, NYN21HRJetsteam Aviation Inc · Cheyenne, WYRegistration ineffective or invalidN220CKKalitta Charters LLC · Ypsilanti, MIN220JJCsc Delaware Trust Co Trustee · Wilmington, DEN220PFExecutive Air Taxi Corp · Bismarck, NDN222KULone Star Storage Trailers Inc · Nolan, TXN222MULanier Air East Coast LLC · Pineville, NCN222NEHigher Cause LLC · Grand Rapids, MIN222PBBlanchard Aviation LLC · Albuquerque, NMN224JL205 Flintstones LLC · Flint, MIN227GJAsi Holdings Inc · New Castle, DEN229DN229d LLC · Stuart, FLN229LJN229lj LLC · Bentonville, ARN22CPRegistered aircraftN232CEN232ce LLC · Newberry, FLN232RV3b Logistics Inc · El Paso, TXN232TAAviation Trading Partners LLC · Shawnee, KSN233KCMp Air LLC · Eagle Point, ORN235LJMango Aviation Parts LLC · Plantation, FLN238AXFabio Lopez · Denver, NCN238DBLewis University · Romeoville, ILN239AXAviation8 LLC · Carle Place, NYN239RTEdg Leasing LLC · Newark, DEN240CKKalitta Charters LLC · Ypsilanti, MIN240VN240v LLC · Wilmington, DE
Back to AD 2012-17-05