AD 2011-22-01
Registered aircraft · 1,167
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:2011-22-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-22-01')
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:2011-22-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-22-01') 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.
N230BDGlobal Pursuits LLC · New York, NYN2313ARegistered aircraftN231CETvpx Ars Inc Trustee · North Salt Lake, UTN2320Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN232HFHf Jet LLC · Beverly Hills, CAN235BHHamilton Aviation Inc · Portland, ORN237GAOrange County/Sunbird Aviation LLC · Costa Mesa, CAN239GACentury Aviation International Inc · Wilmington, DEN239MJG4sp Holdings LLC · West Palm Beach, FLN23DCRegistered aircraftN23DQJfb3 LLC · Atlanta, GAN23UCBay Equipment LLC · Miami, FLN240WLCsc Delaware Trust Co Trustee · Wilmington, DEN241CETvpx Ars Inc Trustee · North Salt Lake, UTN241EABozeman Direct LLC · Summit, NJN242GMTrans-Exec Air Service Inc · Van Nuys, CAN245BDBs Farms Aviation LLC · Menlo Park, CAN245TTWotan America Inc · Fort Lauderdale, FLN247EMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN247WEWwe Jet Services Inc · Stamford, CTN252DVG550 Aviation LLC · Grand Rapids, MIN256CWSrit LLC · Irvine, CAN257ATvpx Ars Inc Trustee · North Salt Lake, UTN25CPWilmington Trust Co Trustee · Wilmington, DEN25GVEast Coast Brokerage Services LLC · West Palm Beach, FLN25HLWilmington Trust Company Trustee · Wilmington, DEN25UTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN261PWPerryair LLC · New York, NYN265HTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN267WAGlobal Aircraft LLC · Eden Prairie, MNN269WRWestgate Aviation Giv LLC · Orlando, FLN26RXRxjet Transportation Services Corp · Oxford, CTN2707Corporate Lift LLC · Farmington Hills, MIN270LEDtaa LLC · Dallas, TXN271GLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN272BGFalcon Landing LLC · Hawthorne, CAN273ATisma Holdings Inc · Fairfax, VAN279SHMeneses Enterprises LLC · Houston, TXN279WRTelemachus LLC · New York, NYN27LXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN27RARadz Air II LLC · El Segundo, CAN280PHJh III LLC · Roseville, MNN283PHGlobal Services Detroit LLC · Detroit, MIN284PHGlobal Services Detroit LLC · Detroit, MIN285PHGlobal Services Detroit LLC · Detroit, MIN293JGEscalante By Grace LLC · Fort Worth, TXN298ALBank Of Utah Trustee · Salt Lake City, UTN2ACTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN2FEFederal Express Leasing Corp · Memphis, TNN2JWJw Air LLC · Houston, TX
Back to AD 2011-22-01