Skip to content

Registered aircraft · 1,210

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:98-15-18-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:98-15-18-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:98-15-18-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:98-15-18-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:98-15-18-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:98-15-18-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.

N90AGEuroaviation Inc Trustee · KematenBuilt 1990 · S/N 11066C N90HLIronrod Aviation LLC · Moorpark, CAS/N 6031C N9103ESanger Henry · Hickman, KYBuilt 1977 · S/N 7099C N9104EGuidry David B · Lake Charles, LABuilt 1977 · S/N 7100C N9114EParkerson Stanley L · Fairbanks, AKBuilt 1977 · S/N 7101C N9125EWhitesell Nowland G · Loudon, TNBuilt 1977 · S/N 6199C N9133EParkerson Stanley L · Fairbanks, AKBuilt 1973 · S/N 7106C N913BN913b LLC · Eau Claire, WIBuilt 1999 · S/N 25035C N913VBCafarelli Peter · Livingston, TXBuilt 1974 · S/N 5001C N9140ESale Reported · Stockholm, SDSale reportedS/N 7112C N9145EScott Alan B · Puyallup, WABuilt 1977 · S/N 6201C N9157EWillard James L · Prosser, WABuilt 1977 · S/N 7114C N9158E7 J Aeroflight Publications Inc · Gruver, TXBuilt 1977 · S/N 7115C N9166EReed John A · El Centro, CAS/N 7117C N9168EAmerson Scott · Lone Oak, GABuilt 1977 · S/N 7118C N916LTTillman Tracy S · Webberville, MIBuilt 2002 · S/N 25088C N916TLYoung Ralph Andrew · Boulder, COBuilt 1985 · S/N 7471C N9176ETyrrells Trails LLC · Fairbanks, AKBuilt 1977 · S/N 7127C N9177EBell Joseph · Lakewood, CABuilt 1977 · S/N 7125C N9179EFrisco Flyers LLC · Macedonia, ILBuilt 1977 · S/N 7128C N9181EDonnelly Thomas G · Seattle, WABuilt 1977 · S/N 7132C N9194EMoore Weston J · Juneau, AKBuilt 1977 · S/N 7129C N91ARBarrier Gary W · Mount Pleasant, NCBuilt 1983 · S/N 7446C N91JHShatz Randy S · Prescott, AZBuilt 1978 · S/N 7238C N91PTClark Daniel E · Rio Linda, CABuilt 1974 · S/N 5024C N91RDWolfe Thomas M · Elizabethville, PAS/N 8071C N91TLAppalachian Wood Preservers LLC · Gladys, VABuilt 1991 · S/N 14012C N9200ETicknor Duane George Jr · Fairbanks, AKBuilt 1977 · S/N 7121C N9202ZRitz Mark A · Anchorage, AKBuilt 1990 · S/N 4084C N92038M7235c LLC · Boulder, COS/N 4085C N9203EWet Wings Inc · Coeur D Alene, IDBuilt 1977 · S/N 7136C N9205EStrong Tobe J · Portage, MIBuilt 1977 · S/N 7131C N9205UWhitford John T · South Weber, UTBuilt 1990 · S/N 7511C N92078Goat Mountain Air LLC · Girdwood, AKS/N 4088C N9207EEast Brian D · Tucson, AZBuilt 1977 · S/N 7133C N9207NPalmer Richard A · Marysville, WABuilt 1990 · S/N 7513C N9209FAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1990 · S/N 4102C N9209QMckeeman Trevor T · Manhattan, KSBuilt 1990 · S/N 14009C N9209YIrvin Vicktar T · Phenix City, ALS/N 14013C N9210MHahn David · Port Lavaca, TXBuilt 1991 · S/N 11067C N92118Plemmons Philip E · Candler, NCS/N 14018C N9213EHolman Michael · Wasilla, AKBuilt 1977 · S/N 7134C N9214FMaule N889z Inc Trustee · Wilmington, DEBuilt 1991 · S/N 4105C N9215XKerr Bryan E · Corvallis, ORBuilt 1991 · S/N 7519C N9217EGranberry Philip · Anchorage, AKBuilt 1977 · S/N 7135C N9217TRegistered aircraftBuilt 1991 · S/N 14020C N9219EStahl Randy F · Fort Benton, MTBuilt 1977 · S/N 7140C N9219YBridgham David A · Plainfield, NHS/N 7514C N9220EBrekken Chris · Prescott, WIS/N 7111C N9223FMckeeman Kevin · Abilene, KSS/N 14039C

Back to AD 98-15-18 R1