Skip to content

Registered aircraft · 1,310

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

N2650HBreza Thomas S · Laud By Sea, FLS/N 3275 N2663HGregory Vernon L · Swansea, SCS/N 3288 N2678HGlasser Gene P · Glen Ullin, NDBuilt 1946 · S/N 3303 N2679HAbrams David E · Boston, MABuilt 1946 · S/N 3304 N2681HFrazier Jesse O · Barnwell, SCBuilt 1946 · S/N 3306 N2698HGoodrich James A · Jacksonville, MOBuilt 1946 · S/N 3323 N26CCook George W · Austin, TXBuilt 1958 · S/N 5661 N26RRightfooted Foundation International · Tucson, AZBuilt 1946 · S/N 3153 N2700HBousquet Arthur David · Highgate Center, VTBuilt 1946 · S/N 3325 N2701HLevsen Charles L · Clinton, IABuilt 1946 · S/N 3326 N2702HHessling Gary G · Trinidad, COBuilt 1946 · S/N 3327 N2704HBoelke Ross D · Armada, MIS/N 3329 N2714HRey Thomas A · Fort Worth, TXS/N 3339 N2715HGregory Vernon L · Swansea, SCBuilt 1946 · S/N 3340 N271HRegistered aircraftBuilt 1946 · S/N 2306 N2727HQuada Andrew W · Lowell, MIBuilt 1946 · S/N 3352 N2730HGregory Vernon L · Swansea, SCBuilt 1946 · S/N 3355 N2735HMorris Robert L · Ulm, MTBuilt 1946 · S/N 3360 N2738HDieter Walter T · Salome, AZBuilt 1946 · S/N 3363 N2747HGregory Vernon L · Swansea, SCBuilt 1946 · S/N 3372 N2749HEngle Elvin Michael · Houston, TXBuilt 1946 · S/N 3374 N2756HSoper Steven E · Rathdrum, IDS/N 3381 N2757HEtchison Don L · Spring Hill, FLBuilt 1946 · S/N 3382 N2758HFitchpatrick Markel C · Blodgett, MOBuilt 1946 · S/N 3383 N2766HBennett Bruce M · Louisburg, KSBuilt 1946 · S/N 3391 N2771HLambertson Paul C · Surprise, AZBuilt 1946 · S/N 3396 N2779JGregory Vernon L · Swansea, SCS/N 976 N2784HHudson Jason M · Toccoa, GABuilt 1946 · S/N 3409 N2785HBal-Air LLC · Boca Raton, FLBuilt 1946 · S/N 3410 N2791HMoore James L · Humboldt, TNBuilt 1946 · S/N 3416 N2795HScholten Dirk J · Ames, IABuilt 1946 · S/N 3420 N2797HWinters David D · Clarksville, TNBuilt 1946 · S/N 3422 N2800HGriggs Geri L · Kingsville, OHBuilt 1946 · S/N 3425 N2806HKass John P · Apple Valley, MNBuilt 1946 · S/N 3431 N2808HBellomy Andrew · Hasty, COS/N 3433 N2816HR & R Outfitters LLC · Kalispell, MTS/N 3441 N281DBMac Mic Aviation LLC · South Saint Paul, MNBuilt 1968 · S/N B-281 N2820HWelkner Brent G · Guyton, GABuilt 1946 · S/N 3445 N2825HMayo Charles S · Woodlawn, TXBuilt 1946 · S/N 3450 N2829HMartin D East · Nicholasville, KYBuilt 1946 · S/N 3454 N2830HPowell Sherman B III · Pulaski, TNBuilt 1946 · S/N 3455 N2831HDon Jones Inc · Orange Beach, ALBuilt 1946 · S/N 3456 N2834HClausing Howard F · Menomonie, WIBuilt 1946 · S/N 3459 N2837HNorberg John E · Eureka, CABuilt 1946 · S/N 3462 N2844HSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 3469 N2845HGoff Frederick Myron · Vernon, CTBuilt 1946 · S/N 3470 N2849HCoupe Brothers LLC · Lopez Island, WABuilt 1946 · S/N 3474 N2860HKerr Phillip D · Beebe, ARBuilt 1946 · S/N 3485 N2864HKarafit James T · Celina, OHBuilt 1946 · S/N 3489 N2865HBayne William R · Kaufman, TXBuilt 1946 · S/N 3490

Back to AD 94-18-04 R1