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.

N4877DAviator Air Flight School LLC · Grand Prairie, TXBuilt 1979 · S/N 17272383 N4877JR&R Aero Services LLC · Eden Prairie, MNBuilt 1979 · S/N 17273687 N48787Angel Aviation Inc · Peoria, AZBuilt 1977 · S/N 15280967 N4878BSun Aircraft Management LLC · Ormond Beach, FLBuilt 1979 · S/N 15283689 N4878Y182b LLC · La Plata, NMBuilt 1980 · S/N 21064026 N4879DMorey Airplane Company Inc · Middleton, WIBuilt 1979 · S/N 17272384 N4880FFkm Air Shuttle LLC · Brooklyn, NYBuilt 1979 · S/N 17273095 N4880GCifelli George J · Dothan, ALFirst renewal noticeBuilt 1979 · S/N 17273427 N4880UYanikoski Joseph A · Stoughton, MABuilt 1984 · S/N 21064831 N48810Training Planes LLC · Tampa, FLBuilt 1977 · S/N 15280976 N48816Feuerlein Maximilian · Tampa, FLBuilt 1977 · S/N 15280979 N4881EFulltron Aviation LLC · Springfield, MOBuilt 1978 · S/N 17271672 N4881QAir Dakota Flite Inc. · Hettinger, NDBuilt 1976 · S/N 18802617T N4881RSheffield Chad F · Muldrow, OKBuilt 1978 · S/N R18200619 N48823Silver Express Co DBA · Miami, FLS/N 15280984 N48836Messenger Air Ltd · Madrid, IABuilt 1977 · S/N 15280993 N4883GPlane Nuts Aviation LLC · Livingston, LABuilt 1979 · S/N 17273430 N48842Elon Aviation LLC · Burlington, NCBuilt 1977 · S/N 15280997 N48848Eaglet Flight Operations Lp · Fort Worth, TXBuilt 1978 · S/N 15281000 N48856Neumeister Brian K · Edwardsville, ILBuilt 1977 · S/N 15281005 N4885DSpartan National Holdings LLC · Missoula, MTBuilt 1979 · S/N 17272386 N4885GS&P Aviation LLC · Albuquerque, NMS/N 17273432 N48868Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15281013 N4886GSkycrafters Inc · Johnson City, TNFirst renewal noticeBuilt 1979 · S/N 17273433 N48878Kilo Lima Investments LLC · Huntington Beach, CABuilt 1978 · S/N 15281023 N48879Matson Dean R · Spring, TXBuilt 1977 · S/N 15281024 N4887GSouthern Aero LLC · Homestead, FLBuilt 1979 · S/N 17273434 N48883Fly Kful Inc · Fullerton, CABuilt 1977 · S/N 15281026 N48887Fault Line Flyers · Leander, TXBuilt 1977 · S/N 15281030 N4888CGoflight Inc · Birmingham, MIBuilt 1979 · S/N 21063656 N4888G578 Airplane Leasing Inc · Kissimmee, FLS/N 17273435 N4888HRudisel Timothy A · Kewadin, MIBuilt 1979 · S/N 15283999 N4888LAshton Marc J · Petaluma, CABuilt 1980 · S/N 15284239 N48895Mulvania Rodney A · Linn, MOBuilt 1977 · S/N 15281037 N4889DPink Skies Inc · Willoughby, OHBuilt 1979 · S/N 17272387 N4889GKittitas Aero Inc · Kittitas, WABuilt 1979 · S/N 17273436 N488BAPlane Nonsense Inc · Middletown, DES/N 17273345 N488EKingdom Air Corps · Sutton, AKBuilt 1977 · S/N 15279654 N488JWKagey David M · Seabrook, TXBuilt 1972 · S/N 17261113 N488LGErnst Donald E · North Pole, AKBuilt 1975 · S/N 14175 N488RDWhitnell Mark A · Lehigh Acres, FLBuilt 1966 · S/N 1300 N488TCKoch Gregory S · Long Beach, MSS/N 465-74 N48900Smtm Holdings Inc · Wilmington, DEBuilt 1979 · S/N 15283387 N4890QNew Frontier Aviation LLC · Fort Benton, MTBuilt 1976 · S/N 18802626T N4890RRebecca Lynn Flying Service Inc · Livingston, NYBuilt 1975 · S/N 18802408T N48918Aero Fliers LLC · Kalispell, MTS/N 15283389 N4891JHarris Aircraft Leasing Co · Oklahoma City, OKBuilt 1979 · S/N 17273691 N48924Cobb Susie O · Fayetteville, TNBuilt 1977 · S/N 15281051 N48932Poursartip Nader · Hayward, CABuilt 1977 · S/N 15281056 N48935Chambers Wyatt Allan · Ludlow, MABuilt 1977 · S/N 15281059

Back to AD 80-25-07 R1