AD 2012-13-12
Registered aircraft · 1,192
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-13-12')
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-13-12')
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-13-12') 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-13-12') 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.
N407DWP A T Productions Aviation LLC · Severna Park, MDN407GKBank Of Utah Trustee · Salt Lake City, UTN408JSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN40VCFuerza Regida Corp · San Bernardino, CAN411LLGlen Hill Sky LLC · Oakbrook Terrace, ILN411LTKent Aviation LLC · Midland, TXN411YMRida Realty Investments Corp · Houston, TXN412JDNormandy'S Triumph LLC · Tampa, FLN412TJ400tj Inc · Newport Beach, CAN414VGBank Of Utah Trustee · Salt Lake City, UTN415BTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN415DSNexa Aviation LLC · Burlingame, CAN415LTTc Business Aviation LLC · San Francisco, CAN415MA8 Windows LLC · Reno, NVN415QSRegistered aircraftN41PMSouthland Holding Group LLC · Beverly Hills, CAN41SCWorld Tech Air 23 LLC · Valencia, CAN420JGDuval Investments LLC · Southfield, MIN421QSRegistered aircraftN424EATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN424JSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN424PXNf Air Ventures LLC · Southfield, MIN427HGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN428KSSn 1360 LLC · Wilmington, DEN429CGRica Air LLC · Castaic, CAN429DDAircraft Trust & Financing Corp Trustee · Wilmington, DEN42JHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN432HCFast Bird LLC · Wilmington, DEN435HCAerobat Ventures LLC · Phoenix, AZN435QSDodson International Parts Inc · Rantoul, KSN437GAAircraft Guaranty Corp Trustee · Oklahoma City, OKN43ADAngstrom Aviation LLC · Southfield, MIN43XTAero Leasing II LLC · Apex, NCN441GCBryancore Aviation LLC · Key Biscayne, FLN442WWAb Jet Co Vii LLC · Metairie, LAN444DHHatley Aviation LLC · Johnson City, TNN444QCGulfstream Giv-1411 LLC · Wilmington, DEN444QGQuad/Air LLC · Sussex, WIN445HCastor-G550 LLC · North Miami Beach, FLN445MDMalcolm Aviation LLC · San Francisco, CAN445QSDodson International Parts Inc · Rantoul, KSN447JFN447jf LLC · New Hudson, MIN448QSNji Sales Inc · Oklahoma City, OKN44CEEvergreen Executive Holdings LLC · North Oaks, MNN44GJN44gj LLC · Camden, DEN44GVN44gv LLC · Pacific Palisades, CAN450ABBlue Vista LLC · Newport Beach, CAN450ARN450ar LLC · Henderson, NVN450BGT Champsions Houston LLC · Dallas, TXN450BTTw Aviation LLC · Jupiter, FL
Back to AD 2012-13-12