Skip to content

Registered aircraft · 54,015

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.

N7144GJc Flight Inc · Wilmington, DEBuilt 1969 · S/N 17258844 N7144MKeno Dale J · Worley, IDBuilt 1958 · S/N 55444 N7144QJungle Breezes Youth Ministries · East Earl, PABuilt 1975 · S/N U20603075 N7144SLet There Be Flight LLC · Portage, MIBuilt 1967 · S/N 15067844 N71450Ejs Enterprises Inc · Three Forks, MTBuilt 1969 · S/N 18259627 N71452Blay Jeffrey E · Oak Harbor, OHBuilt 1969 · S/N 18259629 N7145EJones Robert · Anchorage, AKBuilt 1959 · S/N 52145 N7145QEdling Tyrell R · The Dalles, ORBuilt 1973 · S/N 18262038 N7145TZacharias Norman R · Hinckley, MNFirst renewal noticeBuilt 1959 · S/N 46745 N7145XAthol Orange Aero Club Inc · Athol, MABuilt 1961 · S/N 15059245 N71462Shaffer Jessie J · Peyton, COBuilt 1969 · S/N 18259632 N71463Rodrigo Jodi L · Orland, CABuilt 1969 · S/N 18259633 N7146FR And R Plane LLC · Lewiston, IDBuilt 1966 · S/N 15063746 N7146GHalladay Roy · Erie, COBuilt 1969 · S/N 17258846 N7146MWright Roy E · Tulelake, CABuilt 1958 · S/N 55446 N7146QPressley Aviation LLC · New London, NCBuilt 1972 · S/N 17260446 N7147AAir Cover Academy LLC · Frankford, MOBuilt 1956 · S/N 29247 N7147FHernandez Jorge L · Luthersville, GABuilt 1966 · S/N 15063747 N7147GAffordable Flying LLC · Cedar Park, TXBuilt 1969 · S/N 17258847 N7147TMoody George A II · Dyersburg, TNBuilt 1959 · S/N 46747 N7147XBrooks Blaze W · Fairbanks, AKBuilt 1961 · S/N 15059247 N71484Noss David L Jr · Hominy, OKBuilt 1969 · S/N 18259637 N7148EBush Dale L · Medford, ORBuilt 1959 · S/N 52148 N7148FHigh Flight Aviation Of Kentucky Inc · Lexington, KYFirst renewal noticeBuilt 1966 · S/N 15063748 N7148SJupiter Flight Service And Investing LLC · Lithonia, GAS/N 15067848 N7148XLong Thomas S · Longview, TXBuilt 1961 · S/N 15059248 N71491Kelley Philip W · Titus, ALBuilt 1969 · S/N 18259641 N71494Neverland LLC · Emerson, IABuilt 1969 · S/N 18259643 N7149ASteffanic Matthew R · Bastrop, TXS/N 29249 N7149MBarton Danny B Trustee · White City, ORBuilt 1958 · S/N 55449 N7149QS&H Aviation LLC · Columbus, INS/N 17260449 N7149SMcateer Kristy · East Greenwich, RIS/N 15067849 N7149TRb Associates · North Bend, ORBuilt 1959 · S/N 46749 N714ABHawke Ag Aviation Inc · Oakdale, CABuilt 1976 · S/N 15079017 N714ADRedding Courtland J · Gowen, MIBuilt 1976 · S/N 15079019 N714AEWackman Howard P · Elk Grove, CABuilt 1976 · S/N 15077874 N714AFStoberski John J · Henderson, NVBuilt 1976 · S/N 15079021 N714AGGreenwing Aviation & Welding Co · Lacon, ILBuilt 1976 · S/N 15079022 N714AJMarra Michael A · Carlisle, PABuilt 1976 · S/N 15079024 N714AMRadovanovic Dimitri · Newport Beach, CABuilt 1976 · S/N 15079027 N714APGhiselli William A III Trustee · Woodruff, WIBuilt 1976 · S/N 15079029 N714AQSale Kelly L · Priest River, IDS/N 15079030 N714AZMarsh Gary W · Hopkinsville, KYBuilt 1976 · S/N 15079039 N714BBHunter Jack D · Prattville, ALFirst renewal noticeBuilt 1976 · S/N 15079041 N714BERegistration Pending · Campbell Hall, NYRegistration pendingBuilt 1976 · S/N 15079044 N714BJChandler Scott G · Fortuna, CAFirst renewal noticeBuilt 1976 · S/N 15079047 N714BKZehner Mike W · Boise, IDS/N 15079048 N714BLPeery Harold R · Madill, OKBuilt 1976 · S/N 15079049 N714BNFly Low Aviation LLC · Smithville, MSS/N 15079051 N714BTZielke Michael M · Chuluota, FLBuilt 1976 · S/N 15079056

Back to AD 87-20-03 R2