Skip to content

Registered aircraft · 366

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-21-02-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:81-21-02-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:81-21-02-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:81-21-02-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:81-21-02-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:81-21-02-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.

N6519QFox Thomas B · Steamboat Springs, COBuilt 1966 · S/N RX7-3066 N6526RKugler Donald W Jr DBA · Baptistown, NJBuilt 1987 · S/N S60A-3066 N6526SDavis John C IV · Evergreen, COBuilt 1987 · S/N S50A-3002 N65308Young Derald E · Dixfield, MEBuilt 1987 · S/N S60A-3069 N6563QLake Geneva Balloon Co LLC · Lake Geneva, WIBuilt 1987 · S/N S66A-3021 N6569XSproul Keith A · North Brunswick, NJS/N RX7-3148 N65705Wrigglesworth Mark N · East Amherst, NYBuilt 1989 · S/N RX7-3149 N65778Gallagher Eric J · Downingtown, PAS/N RX7-3162 N65793Lattin Thomas K · Garner, NCBuilt 1988 · S/N RX7-3163 N6580BDuft Jeff M · Eagle River, AKBuilt 1988 · S/N RX7-3164 N6584CBelk William E · Labelle, FLBuilt 1988 · S/N RX7-3109 N65850Gerred Michael S · Bel Air, MDBuilt 1988 · S/N S66A-3023 N65ABGallant Michael T · Columbus, INBuilt 1983 · S/N S55A-1023 N690AMHrechniw Taras K · Ellenville, NYBuilt 1988 · S/N RX7-3169 N69SPHandcraft Furniture Balloon Rides LLC · Lake Tomahawk, WIBuilt 1972 · S/N S40A-122 N70016Albert Daniel L · New Athens, ILBuilt 1994 · S/N S60A-3196 N7029CHigh Plains Drifter Hot Air Balloons LLC · Miles City, MTBuilt 1994 · S/N S60A-3197 N7036HTollefson Tom G · Detroit Lakes, MNBuilt 1994 · S/N S60A-3198 N7036YHicks Jason F · Denver, COBuilt 1994 · S/N S60A-3199 N7078NHayes Melanie · Salt Lake City, UTBuilt 1994 · S/N RX7-3305 N7080XSee Cookie M · Albuquerque, NMBuilt 1994 · S/N RX7-3301 N70979Cato Amie D · Paris, TXBuilt 1995 · S/N S60A-3202 N7097AFenster Matthew · Bellevue, NEBuilt 1994 · S/N RX7-3303 N7097FWilliams Garrett J · Sioux Falls, SDS/N S60A-3201 N7097UStewart Laura R · Decatur, ALBuilt 1994 · S/N RX7-3299 N7099SRegistered aircraftBuilt 1995 · S/N S66A-3056 N7111GJones Christopher J · Billings, MTS/N S55A-3068 N71150Barnes Laura J · Oconomowoc, WIBuilt 1995 · S/N RX7-3309 N7118ASally T Ware · Salt Lake City, UTBuilt 1995 · S/N RX7-3310 N7118FGordon Edward G · Austin, TXBuilt 1995 · S/N RX7-3311 N711EFThornton Floyd R · Saint Louis, MOBuilt 1997 · S/N S60A-3225 N7120MCitadel Communications Corp · Albuquerque, NMFirst renewal noticeBuilt 1995 · S/N S60A-3206 N7126YRobison William M · Fort Worth, TXBuilt 1995 · S/N RX7-3312 N71280Oliviann Balloons LLC · Hodgenville, KYBuilt 1995 · S/N S60A-3205 N7130QMason James J · Albuquerque, NMBuilt 1995 · S/N RX7-3313 N7133URiehle Jacob P · Johnston, IABuilt 1995 · S/N RX7-3314 N71394Korth Brandon C · New London, WIBuilt 1995 · S/N S55A-3066 N7139FHigh Plains Drifter Hot Air Balloons LLC · Miles City, MTBuilt 1995 · S/N RX7-3316 N7139RThomas Nancy P · ChallesNon-citizen corporation, flight hours not reportedBuilt 1995 · S/N RX7-3315 N713DCKrieg Carole L · Independence, ORBuilt 1978 · S/N S55A-423 N71410Stewart Laura R · Decatur, ALBuilt 1995 · S/N RX7-3317 N7144ESchmitz Jon F · Albuquerque, NMBuilt 1995 · S/N S55A-3071 N71520Caton Thomas J · Byrnes Mill, MOBuilt 1996 · S/N S60A-3211 N7153XKrieg Fred W · Independence, ORBuilt 1996 · S/N S55A-3072 N7155JMarketing Services Inc Of Pueblo · Colorado Springs, COBuilt 1996 · S/N S66A-3059 N7156HPerkins Michael D · Las Vegas, NVS/N S60A-3212 N71579Weiscopf Charles W · Roseville, CABuilt 1996 · S/N RX7-3319 N7161MWiser David B · Bixby, OKBuilt 1996 · S/N S60A-3213 N7161NCarreathers Lonnie · Rio Rancho, NMBuilt 1996 · S/N S60A-3214 N7161YGingerich Joseph L · Plain City, OHBuilt 1996 · S/N S55A-3073

Back to AD 81-21-02 R1