Skip to content

Registered aircraft · 17,027

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:72-03-03-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3') 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:72-03-03-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
  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:72-03-03-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
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.

N42820Cordobesa Aviation LLC · Belgrade, MTBuilt 1968 · S/N 18259204 N42823Acs Products Co · Lake Havasu City, AZBuilt 1968 · S/N 18259205 N42826Aero Elite Inc · Wilmington, DEBuilt 1968 · S/N 18259208 N4282QShirley Walter Allen · Bullhead City, AZBuilt 1971 · S/N 17260182 N42831Shuff James S II · Victor, WVBuilt 1968 · S/N 18259209 N42849Moonrise Soaring Inc · Wilmington, DEBuilt 1968 · S/N 18259213 N42851Emmons Steven · Russellville, ARBuilt 1968 · S/N 18259214 N42852Fisch Kurt D · Riverside, CABuilt 1968 · S/N 18259215 N42855Wojteczko Jason A · Derby, KSS/N 18259216 N42858Younggren James H · Hallock, MNS/N 18259218 N4285QShielded Holdings LLC · Katy, TXBuilt 1971 · S/N 17260185 N42865Skylane Partners LLC · Duvall, WABuilt 1968 · S/N 18259224 N42871Registered aircraftBuilt 1968 · S/N 18259226 N42874Kloker Daniel E · Owasso, OKBuilt 1968 · S/N 18259227 N42875Bowes Tyler D · Fremont, OHBuilt 1968 · S/N 18259228 N42876Norcal Flight Center LLC · Lincoln, CABuilt 1968 · S/N 18259229 N42877Allain Patrick C · Brusly, LABuilt 1968 · S/N 18259230 N4287QMonmouth Area Flying Club · Lakewood, NJBuilt 1971 · S/N 17260187 N42887Bratlien Michael D · Aurora, COBuilt 1968 · S/N 18259234 N42888Ahigian Craig S · Laguna Niguel, CABuilt 1968 · S/N 18259235 N4288PMooradian Edward M · Fowler, CABuilt 1968 · S/N 18259194 N4288QN4288q LLC · Myrtle Beach, SCBuilt 1971 · S/N 17260188 N42893Registration Pending · El Paso, TXRegistration pendingBuilt 1968 · S/N 18259239 N42894Comal Aero Inc · Schertz, TXBuilt 1968 · S/N 18259240 N42898Perera Austin L · Barnstable, MABuilt 1968 · S/N 18259242 N42899Smith Charles Max · Canon City, COBuilt 1968 · S/N 18259243 N428BLFlying Money Pit LLC · Des Moines, IABuilt 1965 · S/N 18256552 N428HSSchroebel John Daniel Trustee · Pleasant Hill, CABuilt 1965 · S/N 18256735 N42907Albion Telephone Co · Albion, IDBuilt 1968 · S/N 18259247 N42911Kenney Stuart C · Atlanta, GABuilt 1968 · S/N 18259249 N42912Forouzan Fardad Trustee · Poway, CAS/N 18259250 N42919Tarnutzer Aviation LLC · Wayland, MIBuilt 1968 · S/N 18259253 N4291LRappa Giovanni · Hampton, VABuilt 1966 · S/N 17254360 N4291PVanderploeg Connie · Edmond, OKS/N 0432 N4291WN4291w LLC · Orlando, FLBuilt 1969 · S/N 15071397 N4292QSky Walker Flight School LLC · Adrian, MIBuilt 1971 · S/N 17260192 N4293LO'Hop Robert D · Jones, OKBuilt 1966 · S/N 17254362 N4293QKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1971 · S/N 17260193 N42941Nistler Steve W · Helena, MTS/N 18259259 N42947N42947 LLC · Panama City, FLBuilt 1968 · S/N 18259262 N42949Niemeyer Donald C DBA · Hobart, INBuilt 1968 · S/N 18259263 N4294QOptimized Aviation Services LLC · Huntington Station, NYS/N 17260194 N42951Tiedt Randy · Parkville, MOBuilt 1968 · S/N 18259264 N42955Brown Donald E Jr · Jonesboro, ARS/N 18259265 N4295LBravo Aviation LLC · Rexburg, IDBuilt 1966 · S/N 17254364 N42967Brook Daniel L · Marshall, INBuilt 1968 · S/N 18259269 N4296LBreidenbach Todd J · Sabin, MNBuilt 1966 · S/N 17254365 N4296QAirjohn LLC · Cheyenne, WYBuilt 1971 · S/N 17260196 N42972Anderson Mike D · Mc Alpin, FLBuilt 1968 · S/N 18259271 N42974Tracy Lanning Construction LLC · Westminster, SCBuilt 1968 · S/N 18259272

Back to AD 72-03-03 R3