Skip to content

Registered aircraft · 54,017

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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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.

N5252NKensy Ronald S · Panama City, FLBuilt 1980 · S/N 18267601 N52534Dedon Mark F · Dublin, CABuilt 1973 · S/N 18262659 N52537Chico Cassandra LLC · Chico, CAS/N 18262662 N5253EWarren Clark A · Henderson, NVBuilt 1983 · S/N 18268303 N5253NBlair Jonathon M · Sandpoint, IDBuilt 1980 · S/N 18267602 N5253RAmerican Patrols Inc · Midland, TXBuilt 1974 · S/N 17263467 N5253UKronauge Frank A · Dayton, OHS/N 172RG0302 N52543Berry Curtis L · Williamsport, MDBuilt 1977 · S/N 177RG1206 N52544H & H Planting Company · Duncan, MSBuilt 1973 · S/N 18262668 N52546Eaton Rosemary D · Vernon, NYS/N 17274552 N5254DR&R Aero Services LLC · Eden Prairie, MNBuilt 1979 · S/N 17272473 N5254JWorcester Naa Flying Club · Worcester, MABuilt 1980 · S/N 17273745 N5254KStone To Glass LLC · Lake Worth, FLBuilt 1980 · S/N 17274033 N52554Hermiston Aviation Inc · Hermiston, ORBuilt 1973 · S/N 18262672 N52557Ruby James Edwin Trustee · Hereford, AZBuilt 1973 · S/N 18262674 N5255ABishop Michael J · Lima, OHBuilt 1979 · S/N 21063329 N5255FHirsch Jeffrey D · Lutherville, MDS/N 15073155 N5255KReighley Robert G · Xenia, OHBuilt 1967 · S/N 18258124 N5255NLucas David · Lodi, OHBuilt 1980 · S/N 18267604 N5255UFlight Gear Aviation LLC · Pickerington, OHBuilt 1980 · S/N 172RG0304 N52562Sioux Sky Aviation LLC · Grand Forks, NDS/N 18262676 N52563Concord Flying Club Inc · Lafayette, CABuilt 1973 · S/N 18262677 N52564Electrical Systems Professionals Inc · Trinidad, COBuilt 1973 · S/N 18262678 N52569Kf Air Holdings LLC · Indianapolis, INS/N 17274557 N5256DTall Timber Flying Service LLC · Kalispell, MTBuilt 1979 · S/N 17272475 N5256HHenley Robert J · Jeffersonville, INS/N 17265385 N5256NGospel Ministries International · Collegedale, TNBuilt 1980 · S/N 18267605 N52572Corrosion Savants LLC · Wilmington, DEBuilt 1973 · S/N 18262683 N52577Hartman Edward L · N Canton, OHBuilt 1973 · S/N 18262684 N52578Wall Leslie A Trustee · Stevensville, MDBuilt 1977 · S/N 177RG1207 N52579Urquhart David L · Winchendon, MABuilt 1977 · S/N 177RG1208 N5257EWings 4 Paws LLC · Yulee, FLBuilt 1983 · S/N 18268304 N5257HWellman David H · Eugene, ORBuilt 1975 · S/N 17265386 N5257NAmanda Air Inc · Talladega, ALBuilt 1980 · S/N 18267606 N5257RTheodossiou Chris · Mandeville, LABuilt 1974 · S/N 17263471 N5257SSchumaker Grant E · Wichita, KSBuilt 1980 · S/N R18201526 N52582Wheeler Kevin K · Thornville, OHS/N 177RG1209 N52585Colley Reid W · Pauls Valley, OKS/N 177RG1210 N52587Mcconal Danny · Seminole, TXBuilt 1973 · S/N 18262690 N52589Audritsh John E DBA · Indianapolis, INBuilt 1977 · S/N 177RG1211 N5258ABeta Aviation L L C · Lewes, DEBuilt 1985 · S/N P21000841 N5258BMathis Ryan B · Madison, ALS/N 15283818 N5258NOffcourt Ltd · Del Mar, CABuilt 1980 · S/N 18267607 N5258RZwiesler Thomas F · Ellington, CTBuilt 1974 · S/N 17263472 N5258ZSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1981 · S/N 17275032 N52590Aereo Flyers Inc · Camino, CABuilt 1973 · S/N 18262692 N52593Mccarthy Justin P · Western Springs, ILBuilt 1980 · S/N 17274559 N52595Cotton Christopher S · Dallas, TXBuilt 1973 · S/N 18262696 N5259ECole Charles · Las Vegas, NVBuilt 1959 · S/N 50559 N5259HTrifunovic Stefan · Grosse Pointe Park, MIBuilt 1975 · S/N 17265387

Back to AD 87-20-03 R2