Skip to content

Registered aircraft · 40,471

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-04-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:80-04-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:80-04-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:80-04-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:80-04-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:80-04-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.

N9511KMoore Matt R · Nashville, TNS/N 28-7625182 N95121Preston Aviation LLC · Wilmington, DEBuilt 1969 · S/N 28-25814 N9512CDe Aviation Inc · La Porte, TXBuilt 1978 · S/N 28-7816487 N9512DFerrell Alan B · Arlington, OHBuilt 1958 · S/N 22-6428 N9512HTracy Patrick J · Maddock, NDBuilt 1975 · S/N 17266190 N9512JArapahoe Flight Club LLC · Colorado Springs, COBuilt 1966 · S/N 28-3634 N9512SBlack Daniel L · Spicewood, TXBuilt 1965 · S/N 7GCBA21 N95133Rd Aire LLC · Opelika, ALBuilt 1969 · S/N 28-25818 N9513BLong Michael A · Grand Lake, COBuilt 1981 · S/N 172RG0844 N9513CAgri Business Aviation Inc · Sparta, ILBuilt 1978 · S/N 28-7890418 N9513HHigh Flight Academy LLC · Allison Park, PABuilt 1976 · S/N 17266191 N9513JGlorioso Richard · Plant City, FLBuilt 1966 · S/N 28-3635 N9513LMott Terry W · Hampton, IABuilt 1972 · S/N AA5-0213 N95147Ramirez Ricardo A · San Antonio, TXBuilt 1969 · S/N 28-25822 N9514DAdams David D · West Ossipee, NHBuilt 1958 · S/N 22-6430 N9514HFrerichs John E · Gurley, ALBuilt 1975 · S/N 17266192 N9514JDu Bois Aviation Inc · Chino, CABuilt 1966 · S/N 28-3637 N9514LBiller Mary Catherine · Columbus, OHBuilt 1973 · S/N AA5-0214 N95151Gonzalez-Pinto Carmelo · San Antonio, TXBuilt 1969 · S/N 28-25823 N95154Cen Inc · Sheridan, WYS/N 28-25825 N95157Smutek Brian D · Mio, MIBuilt 1969 · S/N 28-25828 N9515BGrason Aviation LLC · Appleton, WIBuilt 1981 · S/N 172RG0846 N9515DElmer Charles F · Saint Clair Shores, MIBuilt 1958 · S/N 22-6439 N9515JBowman Alex T · Virginia Beach, VABuilt 1966 · S/N 28-3638 N9515KBoyd Matthew · Hudsonville, MIBuilt 1976 · S/N 28-7615209 N95160Registration Pending · Lakewood Ranch, FLRegistration pendingBuilt 1969 · S/N 28-25829 N9516KSmith Dalton L Trustee · Smyrna, DEBuilt 1976 · S/N 28-7615210 N95173First Flight Corporation · San Diego, CABuilt 1969 · S/N 28-25832 N9517DLarson David R · Boerne, TXBuilt 1958 · S/N 22-6433 N9517JBanks Brian H · Zebulon, GABuilt 1966 · S/N 28-3640 N95181Stahl Jason R · Etters, PABuilt 1969 · S/N 28-25835 N9518SSprunk Logan J · Chaffee, NDBuilt 1965 · S/N 7GCB-283 N9518WMarshall Christopher · Oshkosh, WIBuilt 1967 · S/N 28-22944 N95192Kilo Fox Aviation LLC · Saint Joseph, MIBuilt 1969 · S/N 28-25837 N95198Hippen Justin L · Virginia, NEBuilt 1969 · S/N 28-25839 N9519DCraig Reginald S · Deville, LABuilt 1958 · S/N 22-6435 N9519JBarlia David L · Anaheim, CABuilt 1966 · S/N 28-3643 N951ACCotyk Andrew L · Galesburg, MIBuilt 2024 · S/N 90072 N951ANNorth Branch Aviation LLC · Fort Worth, TXBuilt 1974 · S/N AA5-0669 N951HCUsweixin · Sheridan, WYBuilt 1980 · S/N 172RG0282 N951KCN951kc LLC · Rehoboth Beach, DEBuilt 1995 · S/N 2526 N951MKFeliciano Gordon F Jr · Thornton, COBuilt 1977 · S/N AA5B0613 N951RVSeverance Ryan N · Darwin, MNBuilt 2009 · S/N 90337 N951SMBurks Aviation Inc · Hattiesburg, MSBuilt 2004 · S/N 21084C N95203Neptune Aviation Services Inc DBA · Missoula, MTBuilt 1969 · S/N 28-25840 N9520JStaples Laurence C · Makanda, ILBuilt 1966 · S/N 28-3645 N9520SPease Richard C · Snow Camp, NCBuilt 1965 · S/N 8 N95211Massey Aviation LLC · Ashburn, GABuilt 1969 · S/N 28-25843 N95217Laight Kevin · Greeneville, TNS/N 28-25844 N9521HJordan Recreation Development LLC · Clinton, TNBuilt 1975 · S/N 17266197

Back to AD 80-04-03 R2