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.
N832PJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN835HCHood Capital LLC · Hattiesburg, MSN837ZPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN838KEDtc LLC · Newburgh, NYN838SWAlliance Air Parts Acquisitions Corp · Oklahoma City, OKN83ML3harris Technologies Flight Capital LLC · Greenville, TXN83VPRegistered aircraftN83WGCooper Burger LLC · Coral Gables, FLN843FFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN843GXAlesant Air LLC · Miami, FLN846CBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN848JAD S Advisors Inc · Oak Park, ILN84YUTxpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN851WUTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN857GAPpg Industries Inc · West Mifflin, PAN858KETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN85DRegistered aircraftN85JMCook Canyon (Gp) LLC · Dallas, TXN85NVKhosla Ventures LLC · San Jose, CAN85VTvpx Ars Inc Trustee · North Salt Lake, UTN863CMWeh 601 LLC · Wilmington, DEN864JGBowtie Aircraft Xrs LLC · Aventura, FLN865RTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN866BBHff Xpressed LLC · Naples, FLN868KETvpx Ars Inc Trustee · North Salt Lake, UTN869DLN869dl LLC · Kansas City, MON86ANTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN86DQQdn Aviation LLC · New Canaan, CTN870CMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN871FRWilmington Trust Co Trustee · Wilmington, DEN875TMTai Leasing Inc · Mckinney, TXN877SBSb Companies LLC · San Antonio, TXN878DBThorondor LLC · Palo Alto, CAFirst renewal noticeN878GCGraton Economic Development Authority · Rohnert Park, CAN878SCTvpx Ars Inc Trustee · North Salt Lake, UTN87WDWeeks-Davies Aviation Inc · West Palm Beach, FLN880SRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN880XTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN882PXNewage Aviation I LLC · Arcadia, CAN882WRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN883AFunair Corp · Aventura, FLN883SJBank Of Utah Trustee · Salt Lake City, UTN884SGRegistered aircraftN885AREssseaeff Aviation LLC · Jericho, NYN885KTJustifly LLC · Dallas, TXN886BPSun Air Three LLC · Scottsdale, AZN887MMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN887TMTai Leasing Inc · Mckinney, TXN888HEGolden Sky Inc · Camden, DEN888JELeone Management Inc · Camden, DE
Back to AD 2011-22-01