Skip to content

Registered aircraft · 81,733

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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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.

N46269Fox Victor Aviation LLC · Newnan, GAFirst renewal noticeBuilt 1968 · S/N 17257148 N4626HFlying K Enterprises LLC · Midvale, UTBuilt 1979 · S/N 24-0799 N4626JMoonshiner Aviation LLC · Austin, TXBuilt 1968 · S/N 28R-30513 N4626RAlatis Nicholas C · Cincinnati, OHFirst renewal noticeBuilt 1965 · S/N 28-21377 N46275D Gordon Aviation Inc · La Jolla, CABuilt 1978 · S/N 15283027 N46276Johnson Lawrence H · Ava, MOBuilt 1968 · S/N 17257150 N4627FGahan Brian C · Cary, ILBuilt 1976 · S/N 28-7715057 N4627RMayo Craig · Hart, MIBuilt 1966 · S/N 28-21378 N4627YReichel Karl M · Cook, MNBuilt 1971 · S/N 18-8943 N4627ZPope County Aviation LLC · Russellville, ARBuilt 1961 · S/N 22-8142 N46281Cabrera Ramon F · West New York, NJS/N 17257153 N46282Maggie Of The Emerald Coast LLC · Panama City, FLBuilt 1968 · S/N 17257154 N46283West Kentucky Flyers Corp · Murray, KYBuilt 1968 · S/N 17257155 N46284Howard David D · Winner, SDBuilt 1968 · S/N 17257156 N46286Cape May Aerial Advertising LLC · Rio Grande, NJBuilt 1942 · S/N G-95 N46287N46287 LLC · Chehalis, WABuilt 1968 · S/N 17257157 N46288Sullivan Patrick J · Salt Lake City, UTBuilt 1968 · S/N 17257158 N4628JSix Drew · Clinton, OHBuilt 1968 · S/N 28R-30515 N4628RTydc Air LLC · Bloomington, MNBuilt 1965 · S/N 28-21379 N4628ZBratager Jeffrey B · Erskine, MNBuilt 1961 · S/N 22-8144 N46291Sikorsky Igor I III · Kittery, MEBuilt 1968 · S/N 17257160 N46292Globetek Aviation LLC · Raymond, MEBuilt 1968 · S/N 17257161 N46293Keefer Terry · La Verne, CABuilt 1968 · S/N 17257162 N46299Van Anda Aviation LLC · Apopka, FLBuilt 1974 · S/N 17264180 N4629DOrion Aviation Aircraft LLC · Carlsbad, CABuilt 1979 · S/N 17272318 N4629RKrick Dolores E · Airville, PABuilt 1966 · S/N 28-21380 N4629YBarts Flying Service Inc · Storm Lake, IABuilt 1967 · S/N 25-4346 N4629ZCollins Cody W · Palestine, TXBuilt 1961 · S/N 22-8145 N462ABPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010062 N462BTNye Chad · Collinston, UTBuilt 1966 · S/N 28-21817 N462EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2021 · S/N 172S12654 N462FAStratus Pr LLC · New Castle, DEBuilt 2022 · S/N 28020062 N462FLLong James D · West Jefferson, NCS/N 28-7125260 N462JBPlane Nonsense Inc · Middletown, DEBuilt 2004 · S/N 18281362 N462LCRancho Bonito Livestock Company · Menard, TXBuilt 1975 · S/N 18-7509058 N462PAPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010043 N462RVBier David · Salem, WIBuilt 1998 · S/N 24829 N462SPGulf Coast Aviation LLC · New Orleans, LABuilt 2000 · S/N 172S8361 N462TATomlinson Aviation Inc · Ormond Beach, FLBuilt 1979 · S/N 15283554 N462TRChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9462 N462WCHomeland Aviation LLC · Shreveport, LABuilt 2012 · S/N 3166 N46302Jones Lehman M · Claremont, CABuilt 1974 · S/N 17264181 N46303Harbour Aviation LLC · Weatherford, TXBuilt 1968 · S/N 17257171 N46307Harvey Adrian C · Riverside, CABuilt 1968 · S/N 17257174 N46308St Cloud State Univ Aero Club Inc · St Cloud, MNBuilt 1978 · S/N 15283029 N46309Bell 47 Helicopters Inc · Middletown, DES/N 17257176 N4630JSouthrail Aviation LLC · North Charleston, SCBuilt 1979 · S/N 17273655 N4630PGoodfellow Ian A · Palm Beach Gardens, FLBuilt 1960 · S/N 27-148 N4630RHansen Blaine S · Edina, MNBuilt 1966 · S/N 28-21381 N4630TFlyair Flight Academy LLC · Flint, TXBuilt 1972 · S/N 28-7225197

Back to AD 81-18-04 R2