Registered aircraft · 8,734

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

N100009at LLC · Nashville, TNS/N 10000 N1000V1kv LLC · Moultrie, GAS/N 0660 N100DGCirrus Sr22t 2190 Inc Trustee · Wilmington, DEBuilt 2024 · S/N 9952 N100FRQualitair LLC Trustee · MichelstadtBuilt 2003 · S/N 0770 N100JBAirbyars LLC · Spartanburg, SCBuilt 2024 · S/N 10290 N100JCTriple Two Holdings LLC · Naples, FLBuilt 2017 · S/N 1542 N100MJMh Aviation LLC · Glendale, AZBuilt 2007 · S/N 2844 N100PKAllen Chase Enterprises Inc · Oswego, NYBuilt 2024 · S/N 10294 N100PXS & R Air LLC · Amarillo, TXBuilt 2004 · S/N 0953 N100RZEastern Stearman Inc Trustee · Leesburg, VABuilt 2010 · S/N 0034 N100WMValiair Lc Trustee · Casper, WYBuilt 2005 · S/N 1268 N100XZJjk Aviation LLC · Hartland, WIBuilt 2024 · S/N 10040 N100YWMps Aviation LLC · The Villages, FLBuilt 2020 · S/N 2215 N100YYInternational Air Services Inc Trustee · Carson City, NVBuilt 2002 · S/N 1183 N100YZCay Air LLC · North Palm Beach, FLBuilt 2004 · S/N 0814 N100ZWFetch Aviation LLC · Bonita Springs, FLBuilt 2014 · S/N 4086 N1011GInternational Air Services Inc Trustee · Carson City, NVBuilt 2025 · S/N 10795 N1014ARegistered aircraftBuilt 2017 · S/N 1646 N1019PBoondocks Solutions LLC · Tomball, TXS/N 1037 N101BEOne Bravo Echo LLC · Fernandina Beach, FLBuilt 2011 · S/N 3759 N101CDCharlie Delta Aviation LLC · Marietta, GABuilt 2001 · S/N 0101 N101FKSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2008 · S/N 3027 N101GWPlan B Air LLC · Lago Vista, TXBuilt 2007 · S/N 2528 N101MRStick The Landing Aviation LLC · Radford, VABuilt 2006 · S/N 1732 N101MWMaroon Creek LLC · Aspen, COBuilt 2007 · S/N 2823 N101NSNoyes Gerold W · Northfield Falls, VTBuilt 2005 · S/N 1588 N101TPSamurai Ventures LLC · Hillsborough, CABuilt 2025 · S/N 10479 N101VMKrowel Nicholas E · Woodstock, GABuilt 2001 · S/N 0109 N101XMMaier Gerard · Hartford, WIBuilt 2004 · S/N 1226 N101ZACirrus Sr22 10117 Inc Trustee · Wilmington, DEBuilt 2024 · S/N 10117 N102ARValiair Limited Co Trustee · Casper, WYBuilt 2013 · S/N 0463 N102CDSch Aviation Inc Trustee · Sporle Kings LynnBuilt 2000 · S/N 1016 N102CJJordan River Aviation LLC · Madisonville, KYBuilt 2002 · S/N 1237 N102DWFlyboy Aviation LLC · Memphis, TNBuilt 2006 · S/N 1750 N102GGVictor Airways LLC · Canton, GABuilt 2021 · S/N 2730 N102HCMerz Investments LLC · Renton, WABuilt 2024 · S/N 10285 N102JSRegistration Pending · Cresco, PARegistration pendingBuilt 2024 · S/N 9919 N102KWVentura Douglas · Cambridge, MDBuilt 2003 · S/N 0755 N102LTSandjuice LLC · Gainesville, FLBuilt 2002 · S/N 0288 N102PBDeland Air And Sea Brokerage Inc · Deland, FLS/N 0321 N102SRAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2006 · S/N 1864 N102TXAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 2012 · S/N 0412 N102VAVectored Aircraft Leasing LLC · Austin, TXBuilt 2025 · S/N 10511 N103BKFalcon Avion LLC · Paragould, ARBuilt 2025 · S/N 10668 N103CClarity Its LLC · Canton, GABuilt 2002 · S/N 0432 N103EECirrus Djh LLC · Bountiful, UTBuilt 2006 · S/N 2104 N103ERR & J Aviation LLC · Bloomfield Hills, MIBuilt 2016 · S/N 2321 N103FDMidnight Echo LLC · Miami Lakes, FLBuilt 2024 · S/N 9838 N103KEuroaviation Inc Trustee · KematenBuilt 2023 · S/N 10193 N103LCKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2021 · S/N 2281

Back to AD 2024-24-11