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.

N3363PDubois Aviation Inc · Chino, CABuilt 1958 · S/N 23-1320 N33640Red Rooster Rentals LLC · Alto, GABuilt 1975 · S/N 28-7515349 N33641Sutton Aircraft Salvage LLC · Palmer, AKS/N 28-7505161 N33642Smith Gary E · Des Moines, IABuilt 1975 · S/N 28R-7535166 N33648Sadiq Ahmed · Ontario, CABuilt 1975 · S/N 28-7525219 N3364THigh Mesa Aviation LLC · Naturita, COBuilt 1967 · S/N 17700664 N3364WOconnell Killian R · Amherst, MABuilt 1965 · S/N 32-210 N3364XDel Bene Dean A Trustee · Monee, ILBuilt 1966 · S/N 1085 N33655Gordon William S III · Aurora, COBuilt 1975 · S/N 28-7525220 N33659North Central Flight Center LLC · Warwick, RIBuilt 1975 · S/N 28-7515351 N3365BSmith James A · Lyle, WABuilt 1954 · S/N 22-2170 N3366Sutton Aircraft Salvage LLC · Palmer, AKS/N 23-1919 N33661Baker Justin Robert · Red Oak, TXBuilt 1975 · S/N 28-7505163 N33663Brown Tony Mac II · Bowling Green, KYBuilt 1975 · S/N 28R-7535171 N33666Hancock Carl M · Glendale, AZBuilt 1975 · S/N 28-7505165 N33667Aptum Aviation Inc · Hicksville, NYBuilt 1975 · S/N 28-7505166 N33668Northeast Cubs LLC · Wilmington, DEBuilt 1975 · S/N 28R-7535172 N33672Nulton Enterprises LLC · Johnstown, PABuilt 1975 · S/N 28-7515298 N33673Borregard Robert Stephen · San Jose, CAS/N 28-7515306 N33674Beaulieu Marc R · Lewiston, MES/N 28-7525222 N33676Bous Harry John · Cayce, SCBuilt 1975 · S/N 28-7525224 N33679North Star Aviation Inc · Ulysses, KSFirst renewal noticeBuilt 1975 · S/N 28-7505167 N3367PJackson Lee Roy Jr · Needville, TXBuilt 1958 · S/N 23-1324 N3368Big Sky Aviation Inc · Wilmington, DEBuilt 1976 · S/N 100 N33684Coletti John · Grant Park, ILBuilt 1975 · S/N 28R-7535174 N3368TTuley Richard L · Marietta, GARegistration revokedBuilt 1967 · S/N 17700668 N3368WRegistration Pending · Bulverde, TXRegistration pendingBuilt 1965 · S/N 32-214 N3368XI Have A Plane LLC · Lake Oswego, ORS/N 1087 N3368ZWatts Paul D · Weatherford, TXBuilt 1960 · S/N 22-7283 N33691Wide Open Aviation LLC · Kalispell, MTBuilt 1975 · S/N 28-7525227 N33692Horn Justin L · Hearne, TXBuilt 1975 · S/N 28-7505170 N33694Fly LLC · Natchez, MSBuilt 1975 · S/N 32-7500029 N33698Briggs Michael L · Howell, MIBuilt 1975 · S/N 28R-7535181 N3369ADoster Michael L · Nampa, IDBuilt 1953 · S/N 22-1667 N3369ERustmann Richard E · Willimantic, CTBuilt 1978 · S/N 17271520 N3369GCruz Miguel A · Fontana, CABuilt 1963 · S/N MA4-3 N3369MCallen Jerry R Jr · Jerome, IDBuilt 1947 · S/N 12-2218 N3369TBauer Charles · Graceville, MNS/N 17700669 N3369WBlue Sky Aviation LLC · Attleboro, MABuilt 1968 · S/N 32-1054 N3369XCollins Jerod William · Conifer, COBuilt 1966 · S/N 1088 N336AFLaine Carey E · Nevada City, CABuilt 1972 · S/N 17260404 N336BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2019 · S/N 2881098 N336BWAllen Scott L · Ogallala, NEBuilt 2001 · S/N 4352 N336DBGustafson Gary E · Motley, MNBuilt 2005 · S/N 90805 N336FPoskey Charles E · Alabaster, ALBuilt 1984 · S/N 679 N336FSRobinson Charles M Sr · Niceville, FLBuilt 2004 · S/N 14 N336JALundquist Eric John Jr · Houston, TXBuilt 2003 · S/N 81392 N336MAHot Wings Aviation LLC · Fishers, INBuilt 2024 · S/N 28020175 N336MCLewis University · Romeoville, ILBuilt 2022 · S/N 172S12880 N336MKNorth Star Aviation Inc · Mankato, MNBuilt 2018 · S/N 2881087

Back to AD 81-18-04 R2