Registered aircraft · 13,306

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

N249WTReed Christopher · Greeley, COBuilt 2017 · S/N 1535 N24AMFlight Solutions LLC · Carefree, AZBuilt 2019 · S/N 1876 N24ATBobwhite Aviation LLC · Atlanta, GABuilt 2019 · S/N 4768 N24BVAsana Ventures LLC · Rancho Santa Fe, CABuilt 2024 · S/N 10053 N24CAWoodford Aviation Inc Trustee · Wilmington, DEBuilt 2023 · S/N 9318 N24CFAmerica Aviation LLC · Yuma, AZBuilt 1979 · S/N 340A0659 N24CHDagostini Robert A · Mount Aukum, CABuilt 1975 · S/N 21060793 N24CMFirst Move Capital LLC · San Diego, CABuilt 2017 · S/N 1577 N24CRTop Flying LLC · Dover, DEBuilt 2008 · S/N 2923 N24DX618 Enterprises LLC · Sheridan, WYBuilt 2024 · S/N 9768 N24EERomana Mathieu G · Miami Springs, FLBuilt 2008 · S/N 3276 N24EGParent Claude · Austin, TXBuilt 2020 · S/N 4877 N24ENEkman Co LLC · Chapin, SCBuilt 2019 · S/N 4769 N24GKWheels Up LLC · Mesa, AZBuilt 2012 · S/N 0392 N24HSSandoval Ernest D · Cave Creek, AZBuilt 1978 · S/N 21062755 N24LFPro Star Aircraft Sales LLC · Londonderry, NHBuilt 2023 · S/N 9549 N24MWMn Aviation LLC · Dayton, OHBuilt 2011 · S/N 3758 N24NHBeyer Roger · Paw Paw, MIBuilt 1981 · S/N 21064545 N24PAJdf Equipment LLC · San Diego, CABuilt 2025 · S/N 10907 N24PXHornets Nest Aviation Inc · Farragut, TNBuilt 2006 · S/N LIV-502 N24RFAlatenn Construction & Properties LLC · Winchester, TNBuilt 2004 · S/N 1168 N24SLSkye Tess Airlines LLC · Holmdel, NJBuilt 1980 · S/N 414A0610 N24TTStark Asset Leasing LLC · San Diego, CABuilt 2024 · S/N 10055 N24VCAlbertson & Davidson Llp · Mesa, AZBuilt 2024 · S/N 10058 N24WDVc Aviation LLC · Indianola, IABuilt 2022 · S/N 8717 N24YGMh Geriatrics LLC · Orlando, FLBuilt 2015 · S/N 1156 N2500TJ & C Holdings Inc · Laguna Beach, CABuilt 2004 · S/N 41026 N2502QMaxim Aviation LLC · Sugarloaf Key, FLBuilt 2005 · S/N 42076 N2503TLarue Mark C · Leander, TXBuilt 1967 · S/N NAV-4-2503 N2507JDarter Lloyd R · Mountain Grove, MOBuilt 1979 · S/N T18803469T N2507LSimply Southern N2507l LLC · Fayetteville, GABuilt 2005 · S/N 41106 N2509TFarah Gregory · Meredith, NHBuilt 1968 · S/N NAV-4-2509 N2509WDouble D'S LLC · Massillon, OHBuilt 2005 · S/N 41061 N250BWHawk Aviation LLC · Medford, ORBuilt 2019 · S/N 1992 N250CKCirrus Sr22 3421 Inc Owner Trustee · Wilmington, DEBuilt 2009 · S/N 3421 N250DCHightower George Jr · Thomaston, GABuilt 1979 · S/N TK-91 N250JHJh Diaries LLC · Dublin, OHBuilt 2013 · S/N 3993 N250MCErp Transportation LLC · New Hudson, MIBuilt 2019 · S/N 1957 N250PWMdl Aviation LLC · Gilbert, AZBuilt 2025 · S/N 10459 N250SFDelta Alpha LLC · Afton, VABuilt 2011 · S/N 0143 N250SRBackcountryaviation LLC · Scottsdale, AZBuilt 2026 · S/N 11284 N250SXHigh Clouds 22 LLC · Montgomery, TXS/N 3632 N2511GVan Bortel Aircraft Inc · Arlington, TXBuilt 2005 · S/N 41101 N2511XAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2005 · S/N 42063 N2511YPrieur Philip · Suwanee, GABuilt 2005 · S/N 41060 N25120Waconda Concepts LLC · Sturgis, SDBuilt 1985 · S/N 46-8508097 N2512XKeesee Theodore A · Lavonia, GABuilt 2005 · S/N 42077 N2514FVan Bortel Aircraft Inc · Arlington, TXBuilt 2005 · S/N 41093 N2515BIndependent Columbia Aviators LLC · Katonah, NYBuilt 2004 · S/N 41040 N2517XBraun Robert M Trustee · Watkins, MNBuilt 2005 · S/N 42081

Back to AD 2012-10-13