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.

N7901GRaines Adam D · Ridgewood, NJBuilt 1970 · S/N 17259601 N7901PTwo Brothers LLC · Helena, MTBuilt 1969 · S/N 18259640 N7901VBoeder Bradley M · Lakewood, WABuilt 1966 · S/N 18051801 N79021Smith Timothy C Trustee · Riverton, WYS/N 17257816 N79024Jwp Flying Services LLC · Chatfield, MNBuilt 1968 · S/N 17257819 N79027Arrow North LLC · Missoula, MTBuilt 1968 · S/N 17257822 N79028Jdc Aviation LLC · Upland, CABuilt 1968 · S/N 17257823 N7902NUnited States Air Force Owner · Colorado Springs, COBuilt 1968 · S/N R172-0293 N7902ZBuer Bradley W · Suffolk, VABuilt 1963 · S/N 15060002 N79031Smith Robert L II · Spencer, WVBuilt 1968 · S/N 17257826 N79036Buiqui Aerospace Corp · Kissimmee, FLS/N 17257831 N7903BHenderson Ethan D · Argyle, NYBuilt 1957 · S/N 29703 N7903FSmith Troy D · Arcadia, INBuilt 1966 · S/N 15064003 N7903GDunn Patrick J · Denver, COBuilt 1970 · S/N 17259603 N7903NUnited States Air Force · Usaf Academy, COBuilt 1968 · S/N R172-0294 N7903UCohen Bruce Robertson · Estes Park, COBuilt 1964 · S/N 17251903 N7903VQuintas Frank · Palm City, FLBuilt 1976 · S/N 177RG0914 N7903ZStahlman Anna Dell · Beaverton, ORBuilt 1963 · S/N 15060003 N79040Higinbotham Larry L · Littleton, COBuilt 1968 · S/N 17257835 N79042N79042 LLC · Rock Hill, SCBuilt 1968 · S/N 17257837 N79048High Stakes Aviation LLC · Fresno, CABuilt 1968 · S/N 17257841 N7904BWagoner Darrin G · Red Oak, TXBuilt 1957 · S/N 29704 N7904GRight Rudder LLC · Rexburg, IDBuilt 1970 · S/N 17259604 N7904TRoarty Eugene H · Poquoson, VABuilt 1960 · S/N 56604 N7904VKlinkmueller Kurt · North Pole, AKS/N 18051804 N7904XWishart Eric G · Reno, NVBuilt 1961 · S/N 17248404 N79050Batto Jeannie L · Madison, INBuilt 1969 · S/N 17257843 N79052Rose Gary A · Brighton, TNBuilt 1968 · S/N 17257844 N79054N18228 Inc · Williamsburg, VABuilt 1969 · S/N 17257846 N79055Amies John W · Zimmerman, MNBuilt 1968 · S/N 17257847 N79057First Eclipse Limited · Richmond, VABuilt 1968 · S/N 17257849 N7905NUnited States Air Force Owner · Peterson Afb, COBuilt 1968 · S/N R172-0296 N7905TEarnshaw John F Jr · Cheyenne, WYBuilt 1960 · S/N 56605 N7905UAutrey Howard T · Freeport, TXBuilt 1964 · S/N 17251905 N79060K&L Aviation LLC · Prosper, TXBuilt 1968 · S/N 17257851 N79062Pierce Brenden D · Eatonville, WAS/N 17257853 N79063Sprague Todd K · Placerville, CABuilt 1968 · S/N 17257854 N79065Kingston Thomas P · Carmel, INBuilt 1968 · S/N 17257856 N79066Doran Vincent J Jr · Wasilla, AKBuilt 1968 · S/N 17257857 N79068Padgett Leonard Dale · Hobart, OKBuilt 1968 · S/N 17257858 N7906NHuppert Zachary D · Melbourne Beach, FLS/N R172-0297 N7906XNewton Ashlynne S · Yuma, COS/N 17248406 N79071Cottrell Mark C · Leitchfield, KYBuilt 1968 · S/N 17257860 N79072Registered aircraftBuilt 1968 · S/N 17257861 N79074Arrol Keith C · Fairfield, CABuilt 1973 · S/N 18261790 N79079Jones Farm Fresh LLC · Bartlett, TNBuilt 1968 · S/N 17257867 N7907TKdrd Holdings LLC · Texas City, TXS/N 56607 N7907UReifenberger Robert A · Saint Petersburg, FLBuilt 1964 · S/N 17251907 N79080Snider Roger A · Harlem, MTBuilt 1974 · S/N 18801962 N79081James Ferrick · Mechanicville, NYBuilt 1968 · S/N 17257869

Back to AD 87-20-03 R2