Registered aircraft · 81,720

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

N1912PSojourner Field LLC · Kouts, INBuilt 2014 · S/N 22483 N1912THillman Motors Inc · Winter Haven, FLBuilt 1971 · S/N 28R-7135130 N1912YFrokjer Dean C · Saint Croix Falls, WIBuilt 1964 · S/N 207 N1913HOllie And Wally Airlines LLC · Auburn, WABuilt 1977 · S/N 28-7716061 N1913JHaugo Bruce K · Sarasota, FLS/N 4J N1913TWilliams Ronald P · Woodway, TXBuilt 1971 · S/N 28-7125474 N1913YSchmitt William Joseph · Santa Cruz, CABuilt 1964 · S/N 208 N1914AElmore James C Jr · Hedgesville, WVBuilt 1952 · S/N 18-1751 N1914HMiloud Chadd K · Fort Worth, TXBuilt 1977 · S/N 28-7716062 N1914LDeakins Glenn F · Ringgold, GAS/N MB-803 N1914VStephens Thomas E · Blacklick, OHBuilt 1974 · S/N 17263792 N1915AMercatoris Robert B · Meadville, PABuilt 1952 · S/N 18-1756 N1915PParker Joshua J · Hawley, TXBuilt 1955 · S/N 22-2662 N1915TAeromx LLC · West Jefferson, OHBuilt 1971 · S/N 28R-7135132 N1915YJordan S Connor · Elizabeth City, NCBuilt 1964 · S/N 210 N1916JCareer Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13182 N1916YLarsen Adam P · Gresham, ORBuilt 1964 · S/N 211 N1917LEpiphany Airmotive LLC · Frisco, TXBuilt 1976 · S/N M-1817 N1917QMeester Mark L · Intl Falls, MNBuilt 1972 · S/N 177RG0317 N1917YMock Joseph R · Huntsville, TXBuilt 1964 · S/N 212 N1918LBurt Christopher James · Leesport, PABuilt 1976 · S/N M-1813 N1918VCampbell Kevin A · Grayville, ILBuilt 1974 · S/N 17263794 N1919AHolman Terence A · Portland, ORBuilt 1952 · S/N 18-1747 N1919BGoldman Lawrence W · Apex, NCBuilt 1976 · S/N MB-794 N1919EPoklar Norman A · Mount Orab, OHBuilt 1957 · S/N 7AC-5486 N1919FUsda Forest Service Fepp · Columbia, SCBuilt 1979 · S/N 17273011 N1919PBarnett David K · Brock, TXS/N 22-2666 N1919QErickson Bernard L · Moses Lake, WABuilt 1972 · S/N 177RG0319 N1919SBurgess Reilly M · Greene, MEBuilt 1974 · S/N 17263899 N1919UD&S Aviation LLC · Spring, TXBuilt 2025 · S/N 172S13295 N1919YSu Ryan · Saint Augustine, FLBuilt 1964 · S/N 214 N191ABRegistration Pending · Newport, ORRegistration pendingBuilt 1963 · S/N 2471 N191ACLoewen Jason Scott · Wenatchee, WABuilt 1993 · S/N 711-93 N191ARJack Dixon Inc · Haiku, HIBuilt 1977 · S/N 17270069 N191ASGrubb Logan J · Faulkton, SDS/N 91 N191BCZabrosky Air LLC · Cedar Hills, UTBuilt 1973 · S/N 28R-7435088 N191BJClausen Kenneth W · Rosalia, WABuilt 1992 · S/N 21233 N191CACsa Aircraft Leasing LLC · Salt Lake City, UTS/N 17281243 N191CGAugust Aero LLC · Kalispell, MTBuilt 1978 · S/N 191 N191DHLee Kevin B · Beulah, NDBuilt 1999 · S/N 2035 N191DJScallion Leon Ivy · Pine Bluff, ARBuilt 1965 · S/N 3206 N191DKAdriatic Holdings LLC · Cheyenne, WYS/N S/H 191 N191DMOlson Tim O · Saint Onge, SDBuilt 1999 · S/N 426-99 N191FSSouthern Illinois University Board Of Trustees DBA · Murphysboro, ILBuilt 1984 · S/N 15285939 N191GSeratt Timothy G · Harviell, MOBuilt 2015 · S/N TD 1 N191GCHughes Aviation LLC · Bedford, NHBuilt 1991 · S/N 10020 N191HCTrinair Aviation LLC · Hampshire, ILBuilt 1965 · S/N 2992 N191JStyer David B · Pendleton, ORBuilt 1977 · S/N 390 N191JSStaben Jon C · Freeport, ILBuilt 2006 · S/N 0305 N191JWWatkins James P · Bakersfield, CABuilt 2015 · S/N 0269

Back to AD 81-18-04 R2