Skip to content

Registered aircraft · 25,370

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.

N52289Moore Daniel W · Valparaiso, INBuilt 1980 · S/N 17274483 N5228EMayberry Aviation Inc · Mount Airy, NCBuilt 1978 · S/N 17271783 N5228RMtc Leasing LLC · Sandersville, GABuilt 1974 · S/N 17263442 N5228XAirbatic LLC · Huntsville, ALBuilt 1969 · S/N 206 N52290Aa-Aero Inc · Fairfield, NJBuilt 1980 · S/N 17274484 N5229BPisha Vincent R · Kendall, WIBuilt 1979 · S/N 15283812 N5229DMiskell Christopher S · Senoia, GABuilt 1979 · S/N 17272459 N5229EZak Leo P · Oakdale, PABuilt 1978 · S/N 17271784 N5229ROcala Aviation Services Inc · Ocala, FLBuilt 1974 · S/N 17263443 N5229XG B Acro Inc · Grandville, MIBuilt 1969 · S/N 207 N522DCBateson Mark A · Roseville, CABuilt 1974 · S/N 17263169 N522FN522f LLC · Titusville, FLBuilt 1970 · S/N 17258510 N522GCCorkins Research LLC · Greenacres, FLBuilt 1979 · S/N 172RG0091 N522GHQuailridge Aviation LLC · Clarkston, WABuilt 1979 · S/N 21063399 N522SKMajor Air LLC · Charleston, SCBuilt 1980 · S/N 17274456 N5231HTilley Daniel D · Grove City, OHBuilt 1975 · S/N 17265379 N5231RPml Aero Club LLC · Groveland, CABuilt 1974 · S/N 17263445 N5231TRegistration Pending · Cottonwood, AZRegistration pendingBuilt 1981 · S/N R18201839 N5231XHolloway David G · Auburn, CABuilt 1969 · S/N 209 N5232DVella David A · Scottsboro, ALBuilt 1979 · S/N 17272461 N5232KStick & Rudder Club Inc · Waukegan, ILBuilt 1980 · S/N 17274024 N52331St Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1980 · S/N 17274494 N5233ERichmor Aviation Inc · Hudson, NYBuilt 1978 · S/N 17271786 N5233PAero Quest LLC · Olive Branch, MSBuilt 1981 · S/N 15284898 N52341Pacific Fleet Aviation LLC · Rochester, NYBuilt 1980 · S/N 17274496 N52344My Toys Inc · Spartanburg, SCBuilt 1980 · S/N 17274497 N5234DWeeks Robert · Lynden, WABuilt 1979 · S/N 17272463 N5234RLanier Dale J · Willis, TXS/N 17263448 N5234XZonneveld Case M · Hanford, CABuilt 1969 · S/N 684 N5234ZZieg R Daniel · Marathon, FLBuilt 1968 · S/N 17257122 N5235RRegistered aircraftBuilt 1974 · S/N 17263449 N5235XOrtu Gerard · East Hanover, NJBuilt 1969 · S/N 698 N52364Air S & T LLC · San Juan Capo, CAFirst renewal noticeBuilt 1980 · S/N 17274503 N5236HCarter Flygare Inc · Sacramento, CABuilt 1979 · S/N 15284070 N52371Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1980 · S/N 17274505 N5237HSmith Richard D · Powell Butte, ORBuilt 1975 · S/N 17265380 N5238Teague Keith S · East Jordan, MIS/N 701 N52384Jane LLC · Somerset, MABuilt 1980 · S/N 17274506 N5238KOptic Air LLC · Sioux Center, IABuilt 1980 · S/N 17274026 N5239BGanim Rose B · Haydenville, MABuilt 1980 · S/N 15284366 N5239GOverturf Jason · Eureka, MOBuilt 1979 · S/N 17273557 N5239KSmoketown Flight Center LLC · Smoketown, PABuilt 1980 · S/N 17274027 N5239SHunnicutt Donald C · Meridianville, ALBuilt 1980 · S/N R18201521 N523JSOlson Jon II · Drake, NDBuilt 1993 · S/N 24-3305 N523MWJoy Of Flight LLC · Kalispell, MTBuilt 1967 · S/N 670013 N52408Flory Jason E · Fremont, INBuilt 1980 · S/N 17274509 N5240EWilson Brent A · Carmel, INBuilt 1978 · S/N 17271791 N5240RRico Aviation Services Inc · Miami, FLBuilt 1974 · S/N 17263454 N5240UEllison Bradley B · Condon, MTS/N 24-3087 N5240XPaulson Ricky R · Hudson, WIBuilt 1969 · S/N 703

Back to AD 80-25-07 R1