Skip to content

Registered aircraft · 647

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

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:2000-16-52') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-16-52') ORDER BY n_number

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:2000-16-52')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-16-52')
  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:2000-16-52')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-16-52')
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.

N16NSNs Air Leasing LLC · Wilmington, DES/N 7383 N172AEUS Department Of Homeland Security · Washington, DCBuilt 2004 · S/N 3839 N173BHBhh Leasing #4 LLC · Pensacola, FLBuilt 2009 · S/N 4614 N174AHAres Air LLC · Phoenix, AZBuilt 2022 · S/N 9121 N175SCSeminole County Sheriffs Office · Sanford, FLBuilt 2017 · S/N 8430 N176SCSeminole County Sheriffs Office · Sanford, FLBuilt 2024 · S/N 9495 N179AAirbus Helicopters Inc · Grand Prairie, TXS/N 9996 N180QDepartment Of Homeland Security · Washington, DCBuilt 2020 · S/N 8815 N181PLAlpine Air Alaska LLC · Girdwood, AKBuilt 2014 · S/N 7812 N183AEU S Dept Of Homeland Security · Washington, DCS/N 3852 N183SDOrange County Sheriff'S Department · Costa Mesa, CABuilt 2017 · S/N 8376 N184RDepartment Of Homeland Security · Washington, DCBuilt 2022 · S/N 9158 N185SDOrange County Sheriff'S Department · Costa Mesa, CABuilt 2016 · S/N 8125 N186AEUS Department Of Homeland Security · Washington, DCBuilt 2004 · S/N 3872 N187AEUS Department Of Homeland Security · Washington, DCBuilt 2004 · S/N 3846 N188EULashinski Robert D Trustee · Sebastopol, CABuilt 2011 · S/N 7188 N191NRMaryland Natural Resources Police · Stevensville, MDBuilt 2023 · S/N 9382 N191TXTexas Dept Of Public Safety · Austin, TXBuilt 2010 · S/N 4841 N192ADepartment Of Homeland Security · Washington, DCBuilt 2011 · S/N 7184 N194AETemsco Helicopters Inc · Ketchikan, AKBuilt 2001 · S/N 3338 N1964LDepartment Of Homeland Security · Washington, DCBuilt 2022 · S/N 9179 N1977GDepartment Of Homeland Security · Washington, DCBuilt 2022 · S/N 9192 N198AETemsco Helicopters Inc · Ketchikan, AKBuilt 2001 · S/N 3371 N1997GAirbus Helicopters Inc · Grand Prairie, TXS/N 9970 N1CRComanche Maverick Air LLC · Houston, TXBuilt 2016 · S/N 8165 N1MZA Star 350 LLC · Henderson, NVS/N 7300 N203ZDepartment Of Homeland Security · Washington, DCBuilt 2020 · S/N 8811 N20AHAirbus Helicopters Inc · Grand Prairie, TXBuilt 2025 · S/N 9714 N2108JDeparment Of Homeland Security · Washington, DCBuilt 2022 · S/N 9200 N211LAAirbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 9910 N212KPitch Link LLC · New York, NYBuilt 2010 · S/N 7030 N212LAAirbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 9919 N213PFLapd Air Support Division · Los Angeles, CABuilt 2017 · S/N 8340 N215GHBase Camp Aviation LLC · Mccall, IDBuilt 1998 · S/N 3147 N2171CNs Air Leasing LLC · Wilmington, DEBuilt 2001 · S/N 3427 N217HPNs Air Leasing LLC · Wilmington, DEBuilt 2002 · S/N 3628 N218SHSuperior Helicopter Services LLC · Indianapolis, INBuilt 2018 · S/N 8458 N21FYH125 Aviation LLC · Wailea, HIBuilt 2024 · S/N 9465 N221LALapd Air Support Division · Los Angeles, CABuilt 2014 · S/N 7900 N221MTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2019 · S/N 8680 N221PAFa Aviation Logistics Inc · Houston, TXBuilt 2014 · S/N 7851 N223LALapd Air Support Division · Los Angeles, CABuilt 2014 · S/N 7956 N223MTMed-Trans Corp · Denton, TXBuilt 2019 · S/N 8659 N224LALapd Air Support Division · Los Angeles, CABuilt 2022 · S/N 9185 N224MTMed-Trans Corp · Denton, TXBuilt 2022 · S/N 9221 N225LALapd Air Support Division · Los Angeles, CAFirst renewal noticeBuilt 2019 · S/N 8628 N226LALapd Air Support Division · Los Angeles, CAFirst renewal noticeBuilt 2019 · S/N 8636 N226MTLendingclub Bank Na · Boston, MABuilt 2019 · S/N 8671 N227MTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 8892 N227NDHillsborough County Sheriff · Tampa, FLBuilt 2022 · S/N 9296

Back to AD 2000-16-52