Skip to content

Registered aircraft · 8,921

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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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.

N2458PMetcalf Jerry J · Liberal, KSS/N 22-2833 N245AGMummey Jose Pablo · Everett, WAS/N 27-7305187 N245ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496046 N245GTChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 4496489 N245MWArment Christopher · Aberdeen, SDBuilt 1967 · S/N 30-1502 N245TFAir Fleet Holdings LLC · Addison, TXBuilt 2024 · S/N 4496595 N2460VBenson Dustin R · Sheyenne, NDBuilt 1980 · S/N 36-8060024 N2463PCox Christopher · Flovilla, GABuilt 1955 · S/N 22-2838 N2464PAdams Gregory L · Lake Stevens, WABuilt 1955 · S/N 22-2839 N2465AWhite Andrew R · Dubois, WYS/N 22-797 N2466PGriffin Scott M · Springfield, OHBuilt 1955 · S/N 22-2841 N2469ABossola Raymond L · Suffolk, VAS/N 22-806 N2469PMccloud James C · Mokelumne Hill, CABuilt 1955 · S/N 22-2844 N246MWLandrum Stuart · Farmington, MOBuilt 1964 · S/N 30-678 N2471ARink Raymond E · Mimbres, NMBuilt 1952 · S/N 22-809 N2473PAnderson Tony V · Pendleton, ORBuilt 1955 · S/N 22-2848 N2474PSeidel William G Jr · Poway, CABuilt 1955 · S/N 22-2849 N2475ABowser Dwight H · Anchorage, AKBuilt 1952 · S/N 22-818 N2475PErickson Scott L · Omaha, NES/N 22-2796 N2479AWilson Kevin B P · La Mesa, CABuilt 1952 · S/N 20-934 N247TFVisionary Holdings LLC · Missoula, MTBuilt 2025 · S/N 4496612 N2486PWoods Jerry Lee II · Murchison, TXBuilt 1955 · S/N 22-2860 N248KCracker Aviation LLC · Jupiter, FLBuilt 1975 · S/N 27-7654004 N248TFVisionary Holdings LLC · Missoula, MTBuilt 2025 · S/N 4496613 N24MFBrito Manuel · Dillingham, AKBuilt 1955 · S/N 22-3554 N24TEKurtz James F · Bethesda, MDBuilt 1970 · S/N 39-53 N24YCBeauchene Air II LLC · Des Moines, IABuilt 1970 · S/N 27-4551 N2500PLasche James R Jr · Weatherford, TXBuilt 1955 · S/N 22-2861 N2501MSchwietz Thomas E Jr · Strasburg, VAS/N 27-7954068 N2502AAmoah-Kusi Christian · Scappoose, ORFirst renewal noticeBuilt 1952 · S/N 22-815 N2505ASims Kenneth Leon · Desert Hot Springs, CABuilt 1952 · S/N 22-816 N2509PAubort Eric Y · Laguna Hills, CABuilt 1955 · S/N 22-2870 N250BASouthern Cub & Aircraft Restoration LLC · Pensacola, FLBuilt 1971 · S/N 25-5425 N250BDSalom Auguste G · Old Orchard Beach, MEBuilt 1965 · S/N 27-3082 N250CCAerodynamics Worldwide Inc · Wilmington, DEBuilt 1960 · S/N 24-1931 N250FDTailwind Aviation Inc · Sault Sainte Marie, MIBuilt 1976 · S/N 27-7654148 N250GTComanche Golf Tango LLC · Clifton, VAS/N 24-2496 N250LJCarew Aviation Inc · Appleton, WIBuilt 1964 · S/N 24-3393 N250PCHerndon Timothy M · Kingston, OKBuilt 1959 · S/N 24-1133 N250RBWestern Slope Aviators LLC · Delta, COBuilt 1958 · S/N 24-334 N250RTMatthews Aviation LLC · Hardinsburg, KYBuilt 1971 · S/N 27-4681 N250TASunset Aviation LLC · Halifax, PABuilt 1974 · S/N 27-7405364 N250TJTalley John T · Clifton, TXBuilt 1959 · S/N 24-1048 N2510MYonder Corp · Wilmington, DEBuilt 1979 · S/N 27-7954070 N2512PMiller Christopher M · Centreville, VAS/N 22-2874 N2513PLeon Bernardo Eucario Moreno · Missouri City, TXBuilt 1955 · S/N 22-2875 N2515PMalone Rex A · Rowlett, TXBuilt 1955 · S/N 22-2877 N2516PNidle Jeffery C · Leasburg, NCBuilt 1955 · S/N 22-2878 N2516ZBig Sea Enterprises Inc · Wilmington, DEBuilt 1980 · S/N 27-8054039 N2518PRife Ramon K Jr · Casper, WYBuilt 1954 · S/N 22-2383

Back to AD 85-02-05 R1