Skip to content

Registered aircraft · 25,368

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

N994RSShane Richard D · Canandaigua, NYBuilt 1978 · S/N 15282505 N994TAmerican Champion Aircraft Corp · Rochester, WIBuilt 2026 · S/N 1235-2026 N99508Lee Randall Ross · Houston, TXBuilt 1985 · S/N 17276456 N99517Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276459 N9951V9951v Aircraft Leasing LLC · Spanish Fork, UTS/N 17264569 N99527Delta State University · Cleveland, MSBuilt 1985 · S/N 17276460 N99532Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276462 N9954LRao Niserg · Columbus, MSS/N 670487 N99553Jka LLC · Notasulga, ALBuilt 1985 · S/N 17276465 N9955CBrenna Matt R · Austin, TXBuilt 1978 · S/N R18200491 N9955JMehling Robert C · Hardin, MTS/N T18803884T N9957EReisman Richard H · Montrose, COBuilt 1979 · S/N 17272298 N99583Motz Gary A · Bemidji, MNBuilt 1985 · S/N 17276471 N99589Kingsky Flight Academy LLC · Lakeland, FLBuilt 1985 · S/N 17276472 N99598Registration Pending · Argyle, TXRegistration pendingBuilt 1985 · S/N 17276474 N9959YGrand Aviation LLC · Winter Park, COFirst renewal noticeBuilt 1982 · S/N 21064648 N995JAN995ja LLC · Ft Lauderdale, FLBuilt 1974 · S/N 17263989 N995JDCarrol Mears Farms Inc · Newport, ARS/N 13502003 N995VZMeyerowitz Noah A · Great Barrington, MABuilt 1974 · S/N 177RG0478 N995WMHangar 7 Aviation LLC · N Redngtn Bch, FLBuilt 1999 · S/N 845-99 N99606Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276478 N9960EArklamiss Aviation LLC · Ruston, LAS/N 17272299 N9961ERuryk Jonathan D · Pineville, LABuilt 1979 · S/N 17272300 N9961VCk Leasing Services LLC · Wilmington, DEBuilt 1974 · S/N 17264579 N9963EDenski David T · Plymouth, MIBuilt 1979 · S/N 17272301 N9963YN9963y LLC · Provo, UTBuilt 1982 · S/N 21064649 N9964LHess Garrett J · Fullerton, CABuilt 1986 · S/N 17276652 N9964YGreenspun Mark H · Washington, DCBuilt 1982 · S/N 21064650 N9966VLeisner David L · Palmer, AKBuilt 1974 · S/N 17264584 N9967CJoemac Business Services LLC · Casper, WYBuilt 1978 · S/N R18200492 N9968CPaulin Gregory H · Flagstaff, AZBuilt 1978 · S/N R18200493 N9968JBoening Bros Dusting & Spraying Scv · Floresville, TXBuilt 1981 · S/N T18803897T N9968LMw Flying LLC · Sanford, NCBuilt 1986 · S/N 17276654 N9968NBuhannic Patrick A · Shepherdstown, WVS/N 21063259 N9968VCynthiana Flying Group Corp · Cynthiana, KYBuilt 1974 · S/N 17264586 N99697Sky High Leasing Services LLC · Lakeland, FLBuilt 1985 · S/N 17276494 N9969BGreenwalt Bert · Jonesboro, ARBuilt 1982 · S/N 172RG1101 N9969CAttitude Indicators LLC · Allegan, MIBuilt 1978 · S/N R18200494 N9969VCosta William · Farmington Hills, MIBuilt 1974 · S/N 17264587 N996MJStefanick Richard L · Morgantown, WVBuilt 1996 · S/N 24-3390 N996MWWiehl In The Sky LLC · Mount Juliet, TNBuilt 1973 · S/N 17262434 N99700Lee Rich · Carlsbad, CABuilt 1985 · S/N 17276496 N99709Long Island Aviators LLC · Seaford, NYBuilt 1985 · S/N 17276498 N9970VSpalding Flying Club LLC · Griffin, GABuilt 1974 · S/N 17264588 N99712Nesher Aviation II LLC · Jacksonville, FLBuilt 1985 · S/N 17276499 N99715N99715 LLC · Wheeling, ILS/N 17276501 N9971EGuerrero-Reyes Fernando G · Princeton, NJBuilt 1979 · S/N 17272304 N99725Holladay Aviation LLC · Jacksonville, FLBuilt 1985 · S/N 17276502 N9972TOliver Randy Martin · Kent, WABuilt 1978 · S/N 38-78A0266 N9972VMotley Charlotte J · Summerdale, ALBuilt 1974 · S/N 17264590

Back to AD 80-25-07 R1