Skip to content

Registered aircraft · 20,683

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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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.

N5907RBrown Kriss · Naperville, ILBuilt 1965 · S/N 17253576 N5908APomeroy Cattle Ranch LLC · Kalispell, MTS/N 28508 N5909ARyan Michael W · Rincon, GABuilt 1956 · S/N 28509 N5909EOwens Flight Training LLC · Lafayette, LABuilt 1978 · S/N 17271958 N5909RWagner Christopher J · Tulsa, OKBuilt 1965 · S/N 17253578 N590SProspect Ridge Aviaton Inc · Morganton, NCBuilt 1981 · S/N 172RG0818 N590SPTubreaux Aviation Services LLC · Shreveport, LABuilt 2000 · S/N 172S8520 N5910AAlumbaugh Ian M · Mcpherson, KSBuilt 1956 · S/N 28510 N5913RWilliams Alonzo · Bentonville, ARBuilt 1965 · S/N 17253582 N5914RWaldrop Charles Trustee · Oklahoma City, OKBuilt 1965 · S/N 17253583 N5915AMyers Glen L · Grassy Butte, NDBuilt 1956 · S/N 28515 N5916JUnited States Air Force - Owner · Eglin Afb, FLBuilt 1980 · S/N 17273845 N5917RParcell Evelyn Cassandra · Norfolk, VAS/N 17253586 N5919AFederico Gilbert · Litchfield Park, AZBuilt 1956 · S/N 28519 N5920A20 Awesome LLC · Albuquerque, NMBuilt 1956 · S/N 28520 N5920RAmerican Eagle Aviation LLC · Flushing, MIBuilt 1965 · S/N 17253589 N5922AArmiger Scott L · Holly Springs, NCBuilt 1956 · S/N 28522 N5922EAerial Scouting Solutions LLC · Sioux Center, IABuilt 1978 · S/N 17271963 N5923ARowlett Glen R · Brookshire, TXBuilt 1956 · S/N 28523 N5927ASamaritans Purse · Boone, NCS/N 28527 N5927RRodrigues Robert R · Cordova, AKS/N 17253596 N5928AToribio LLC · San Antonio, TXBuilt 1956 · S/N 28528 N5928EGace Flying Club Inc · Ronkonkoma, NYBuilt 1978 · S/N 17271964 N5929TFlight School Of Gwinnett Inc · Lawrenceville, GABuilt 2002 · S/N 17281105 N592CPCivil Air Patrol · Maxwell Afb, ALBuilt 2021 · S/N 172S12731 N5930AUthe Wendy G · Wellsville, MOBuilt 1956 · S/N 28530 N5930RDownwind Corp · Brush Prairie, WAS/N 17253599 N5932AAquila Aviation LLC · Pompano Beach, FLBuilt 1956 · S/N 28532 N5933AWicklander Richard O · Spanaway, WABuilt 1956 · S/N 28533 N5934AJenkins Brian T · Batesville, INBuilt 1956 · S/N 28534 N5934RHoyt Jacob T · Oneida, NYS/N 17253603 N5935ADunn James Blair Jr · Bumpass, VABuilt 1956 · S/N 28535 N5935RStofer William B · Warsaw, INBuilt 1965 · S/N 17253604 N5937RDavies Shane E · Kent, WAS/N 17253606 N5938ALand-O-Matics LLC · Wilmington, DEBuilt 1956 · S/N 28538 N5939RHester James T · Fayetteville, GAS/N 17253608 N593STN593st LLC · Bangor, MEBuilt 1985 · S/N 17276454 N5940RBakrevski Lupcho · Valparaiso, INS/N 17253609 N5941RChristian Stuart J · Erskine, MNS/N 17253610 N5942RL&L Ltd · Shoreview, MNBuilt 1965 · S/N 17253611 N5943AFox Michael S · Glendale, AZS/N 28543 N5943EPlane Zane LLC · Stuart, FLBuilt 1978 · S/N 17271969 N5943RGear Down Hangar LLC · Phoenix, AZBuilt 1965 · S/N 17253612 N5944RLucas Heaven · Griffin, GABuilt 1965 · S/N 17253613 N5945RDamme Douglas A · Talmage, NEBuilt 1965 · S/N 17253614 N5946AKessinger John · Independence, ORS/N 28546 N5946RElite Aeronautics LLC · Miami, FLBuilt 1965 · S/N 17253615 N5947ARoberts James L · Sedgwick, KSBuilt 1956 · S/N 28547 N5947NGmm Records · Big Pine Key, FLBuilt 1972 · S/N 17260597 N5947RDillon Aero Inc · Phoenix, AZBuilt 1965 · S/N 17253616

Back to AD 90-06-03 R1