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.
N162JCSloan Harry Evans Trustee · Woodland Hills, CAN162QSRegistered aircraftN163EGC Dot Aviation LLC · Dover, DEN163QSRegistered aircraftN164QSRegistered aircraftN165QSRegistered aircraftN165VTMansfield Heliflight Inc · Milton, VTN166AAE D Santos & Associates LLC Trustee · Wilmington, DEN166QSRegistered aircraftN167QSRegistered aircraftN167TVTeam Unicorn LLC · Hingham, MAN168CEInternational Aero Services LLC · Bellflower, CAN168NWTvpx Ars Inc Trustee · North Salt Lake, UTN168PKPmc Global Inc · Sun Valley, CAN168QSRegistered aircraftN169QSRegistered aircraftN169SDBank Of Utah Trustee · Salt Lake City, UTFirst renewal noticeN16MFRegistered aircraftN17018Bank Of Utah Trustee · Salt Lake City, UTN173NYBlf Aircraft Holdings LLC · Irvine, CAN175KHTvpx Trust Co LLC Trustee · North Salt Lake, UTN176SMBizav Support LLC · Fort Lauderdale, FLN1799CTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN17FJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN17RXRxjet Transportation Services Corp · Oxford, CTN180PETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN1852VG200 LLC · San Juan, PRN1875AUS Bank Na Trustee · Wilmington, DEN1878EGalaxy Lift LLC · New York, NYN188JHaut Enterprises LLC · North Kingstown, RIN188WBank Of Utah Owner Trustee · Salt Lake City, UTN18BNWorld Rep LLC · Toa Baja, PRN18CJ18cj LLC · Norfolk, VAN18GNNair LLC · Purchase, NYN18HInfinity & Beyond LLC · South Bend, INN18NNSlj Acquisition LLC · Gainesville, FLN18S5531 LLC · Seattle, WAN18TMAerownership North American Services Inc Trustee · Wilmington, DEN18WZEwz Aviation Inc · Santa Monica, CAN1901GChevron U S A Inc · Sugar Land, TXN190JAJacob Wing LLC · New York, NYN1932PMozart Investments Inc · Roanoke, VAN1948ZTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN194MFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN1955QGmdair Corp · New York, NYN1956MRegistered aircraftN1964MTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN1967JEagle Mountain International Church Inc · Newark, TXN1989Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN198RLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UT
Back to AD 2011-22-01