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.

N18BGTommervik Sean · Philadelphia, PAS/N 02G N18CKHatch Aviation LLC · New Braunfels, TXBuilt 2017 · S/N 1581 N18CYBraylin Air LLC · Jupiter, FLBuilt 2018 · S/N 1740 N18DLBelov Mikhail · Greenwood Village, COBuilt 1977 · S/N 310R1251 N18DNZba LLC · Hurricane, UTBuilt 2001 · S/N 0096 N18EGBoanco Inc · Lafayette, INBuilt 1973 · S/N 414-0394 N18EUCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11416 N18GGLogan Rob · Watervliet, NYBuilt 2002 · S/N 134 N18MRMorey Airplane Co Inc · Middleton, WIBuilt 1978 · S/N 340A0557 N18PYHeavenly Flight LLC · Cumming, GABuilt 2022 · S/N 8856 N18SAWatkins Aviation LLC · Kenton, OHBuilt 2005 · S/N 1401 N18SBTroy Motz Construction Inc · Lincolnton, NCBuilt 1978 · S/N 18266338 N18SYWingz Wi LLC · Milwaukee, WIBuilt 2024 · S/N 10038 N18VGBullet Aviation LLC · Missoula, MTBuilt 1999 · S/N E-3255 N18VJAssurance Data Inc · Indiana, PABuilt 1984 · S/N TJ-445 N18VRVentura Air LLC · Wilmington, DEBuilt 1996 · S/N TH-1771 N18WDSeferiadis David · North Wales, PABuilt 2017 · S/N 4513 N18WGBest Way Flights LLC · Magnolia, TXBuilt 2015 · S/N 4250 N18WWFourth Sister LLC · Wilmington, DEBuilt 1994 · S/N E-2860 N1905B605 Aviation LLC · Aberdeen, SDBuilt 1978 · S/N 414A0214 N1905ERusso Louis A Jr · Houston, TXBuilt 1979 · S/N 340A0664 N1908GAir Z Flying Service Inc · Richmond Heights, OHBuilt 1974 · S/N 310R0055 N190CCWayside LLC · Wilmington, DEBuilt 1984 · S/N 46-8408045 N190DRLehrke Thomas Alan · Bloomington, MNBuilt 2001 · S/N 29-0279 N190DWSouthern Sky Ventures LLC · Lewes, DEBuilt 2003 · S/N 42002 N190JHAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2010 · S/N 3660 N190SRFlyby Air LLC · New Orleans, LABuilt 2007 · S/N 2641 N1915WPasha Mohammad A · Muscatine, IABuilt 1971 · S/N 310Q0429 N1918EGuano Air LLC · Palmetto Bay, FLBuilt 1979 · S/N 340A0668 N1919VHigh Mountain Properties LLC · Idaho Falls, IDBuilt 1984 · S/N T30300271 N191AHCirrus Sr22t Athens Blue Inc Trustee · Wilmington, DEBuilt 2021 · S/N 2354 N191BSChambers Jason Daniel · Marion, MTBuilt 2007 · S/N 2733 N191DWLexo Enterpirses · Houston, TXBuilt 2003 · S/N 42022 N191JBGraeves Auto & Appliance Inc · Olney, MDBuilt 2016 · S/N 1396 N191KMDodson International Parts Inc · Rantoul, KSS/N 0017 N191LRRoutman Leone Aircraft LLC · Fort Lauderdale, FLBuilt 1994 · S/N TH-1720 N191WLHatchery Investments LLC · Truckee, CABuilt 2015 · S/N 1098 N191WTBrightpipe Air LLC · Mableton, GABuilt 2025 · S/N 11057 N1920EHappy Trails Flight Training & Charters LLC · Helena, MTBuilt 1979 · S/N 340A0669 N1923PPremium Air LLC · Hibbing, MNBuilt 2018 · S/N 4610 N1924W1824 Whiskey LLC · Golf, ILBuilt 2023 · S/N 9493 N192AFWarren E Mack LLC · Minneapolis, MNBuilt 1980 · S/N 414A0496 N192AGBp Aviation LLC · Gilbert, AZBuilt 2005 · S/N 29-0406 N192BCLeo Aviation Inc · Rogers, ARBuilt 2024 · S/N 10246 N192BSIntoodeep Industries LLC · Palm Bay, FLS/N 2753 N192CMFriehe Berend · Moses Lake, WABuilt 1981 · S/N U20606160 N192JKWest Gregory B · Cummings, GABuilt 2004 · S/N 29-0353 N1931MAnchor Aviation LLC · Johnstown, COBuilt 2024 · S/N 10392 N193DWGilbert Louis Vincent · Houston, TXBuilt 2004 · S/N 42043 N193FBDiamond Sage LLC · Herndon, VABuilt 2000 · S/N 30-0054

Back to AD 2012-10-13