Skip to content

Registered aircraft · 54,017

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:87-20-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:87-20-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:87-20-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:87-20-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:87-20-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:87-20-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.

N42849Moonrise Soaring Inc · Wilmington, DEBuilt 1968 · S/N 18259213 N4284FNolen Collin · Newman Lake, WABuilt 1958 · S/N 46184 N4284PEmpire Aviators LLC · Long Island City, NYS/N 17264088 N4284UBaker Ranches Inc · Baker, NVBuilt 1963 · S/N 15060284 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 N4286VArquer Nicholas R · Rancho Cucamonga, CABuilt 1948 · S/N 18700 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 N42889Fuller Lawrence A · Wasilla, AKBuilt 1973 · S/N 18052382 N4288PMooradian Edward M · Fowler, CABuilt 1968 · S/N 18259194 N4288QN4288q LLC · Myrtle Beach, SCBuilt 1971 · S/N 17260188 N4288UPiper Kenneth R · Orwell, VTBuilt 1964 · S/N 15060288 N4288VPeck Kenneth L · Smithville, TXBuilt 1948 · S/N 18646 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 N4289VRosborough Todd · Medford, ORBuilt 1948 · S/N 18647 N428AKOlsen Martin G · Anchorage, AKBuilt 1976 · S/N 18502917 N428BLFlying Money Pit LLC · Des Moines, IABuilt 1965 · S/N 18256552 N428HCNott Terry · Overland Park, KSBuilt 1979 · S/N 15283916 N428HSSchroebel John Daniel Trustee · Pleasant Hill, CABuilt 1965 · S/N 18256735 N428RGGandolfo Air LLC · Watertown, CTBuilt 1973 · S/N 17262092 N42907Albion Telephone Co · Albion, IDBuilt 1968 · S/N 18259247 N4290FRussi Kent S · Caldwell, IDBuilt 1958 · S/N 46190 N42911Kenney Stuart C · Atlanta, GABuilt 1968 · S/N 18259249 N42912Forouzan Fardad Trustee · Poway, CAS/N 18259250 N42916Nedwick Lars I · Girdwood, AKS/N 18052384 N42919Tarnutzer Aviation LLC · Wayland, MIBuilt 1968 · S/N 18259253 N4291LRappa Giovanni · Hampton, VABuilt 1966 · S/N 17254360 N4291PVanderploeg Connie · Edmond, OKS/N 0432 N4291QRegistered aircraftBuilt 1976 · S/N U20603043 N4291UTheis Industrial Leasing Inc · Spivey, KSBuilt 1963 · S/N 15060291 N4291WN4291w LLC · Orlando, FLBuilt 1969 · S/N 15071397 N4292QSky Walker Flight School LLC · Adrian, MIBuilt 1971 · S/N 17260192 N4292UHayes John Lue · Shady Cove, ORFirst renewal noticeBuilt 1963 · S/N 15060292 N4292VPowers James E · Elk, WABuilt 1948 · S/N 18650 N4293LO'Hop Robert D · Jones, OKBuilt 1966 · S/N 17254362 N4293QKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1971 · S/N 17260193

Back to AD 87-20-03 R2