Skip to content

Registered aircraft · 6,349

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-02-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:80-25-02-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:80-25-02-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:80-25-02-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:80-25-02-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:80-25-02-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.

N4983MMccray Todd · Saint Augustine, FLBuilt 1980 · S/N 15284497 N4983ZKoerner Aviation Inc · Kankakee, ILBuilt 1961 · S/N 22-8592 N49848Linder Robert E Jr · Conway, ARBuilt 1978 · S/N 15281357 N4984ZRegistered aircraftS/N 22-8593 N49862California In Nice Inc · San Jose, CABuilt 1978 · S/N 15281366 N49864Purkinje Ltd LLC · Wilmington, DEBuilt 1978 · S/N 15281368 N4986ZAlbers William J · Sidney, OHBuilt 1961 · S/N 22-8594 N49872Eaglet Flight Operations Lp · Fort Worth, TXBuilt 1978 · S/N 15281373 N49878Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15281377 N4988HBent James L Jr DBA · Palatine Bridge, NYS/N 18-1955 N49899Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15281381 N4990ZHanson Ethan C · Blanchard, NDBuilt 1961 · S/N 22-8598 N49916Clemence Richard · Southbridge, MABuilt 1978 · S/N 15281392 N4991ZSenneff James L · Clarence, NYBuilt 1961 · S/N 22-8599 N49931Monterey Bay Aviation Inc · Watsonville, CABuilt 1978 · S/N 15281402 N4994ZAom Aircraft LLC · Wilmington, DES/N 22-8604 N49950Fremont Aviation Inc · Fremont, NEBuilt 1978 · S/N 15281410 N49952Mccarthy Robert W · Rockford, ILBuilt 1978 · S/N 15281412 N4995ZBoyer James A · Lancaster, OHBuilt 1961 · S/N 22-8605 N4997ZRoyal Flush Farms LLC · Davey, NEBuilt 1961 · S/N 22-8607 N49988Johnnys Air Service LLC · Senoia, GABuilt 1978 · S/N 15281428 N49993Starr LLC · Superior, WIBuilt 1978 · S/N 15281431 N49994Mdr Rental Corp · Ann Arbor, MIBuilt 1978 · S/N 15281432 N4999ZMendoza Justin · Paso Robles, CABuilt 1961 · S/N 22-8544 N49DCSpencer William D · Martinsville, VAS/N 01 N49DWRamsey Keith W · Morrison, TNBuilt 1987 · S/N 463 N49JAGolden Age Air Museum · Bethel, PABuilt 1999 · S/N 174 N49NHNehemiah Aviation LLC · Leavenworth, KSBuilt 1975 · S/N 1106-75 N49PCFoster David W · North Fort Myers, FLS/N 16-194 N49SMMaxwell Edward · Louisville, KYBuilt 2009 · S/N 001 N4DKDavey Kenneth E · Lake Crystal, MNBuilt 1975 · S/N 83 N4ETReilly Herbert V · Bloomingburg, NYBuilt 1946 · S/N 12-121 N4JMParker Trevor L · Piqua, OHBuilt 1988 · S/N 1179 N4JZWright Earl A · Jasper, FLS/N 836 N4LUWalker Robert W · Cedar Hill, TNBuilt 1977 · S/N AA1C0033 N4UNXin Han Aviation LLC · Atwater, CABuilt 1979 · S/N 1324-79 N4WXParks Richard O · Arlington, WABuilt 2001 · S/N 368 N4ZZSwain Kenneth C · Harvard, ILBuilt 1978 · S/N 229 N5000ZFinan Jeffrey J · Sammamish, WAS/N 22-8609 N5001ZSorby Steven R · Lyman, WAS/N 22-8610 N50026Grant Larry J · Reno, NVBuilt 1988 · S/N 8117 N5002ZBuce Jake T · Kimberly, ORBuilt 1961 · S/N 22-8613 N5005ZGerker David W · Fort Jennings, OHBuilt 1961 · S/N 22-8616 N5006ZShort Colton R · Force, PABuilt 1961 · S/N 22-8617 N5007ZRabe John C · Lincoln, NES/N 22-8618 N5010ZSchwagerman William C · Kingsville, MOBuilt 1961 · S/N 22-8621 N5011ZHarders Justin · Cairo, NES/N 22-8624 N5014ZHicks Francis · Elizabeth, PABuilt 1961 · S/N 22-8629 N5015ZQuirk Charles Leo · Lake Charles, LABuilt 1961 · S/N 22-8630 N5018ZDowning John D · Marion, MIBuilt 1961 · S/N 22-8633

Back to AD 80-25-02 R2