Skip to content

Registered aircraft · 6,916

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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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.

N9160PHeath Allen W · Westlake, TXBuilt 1966 · S/N 24-4648 N9161PAven Michael D · Georgetown, INBuilt 1966 · S/N 24-4649 N9162PBrown Nathan B · Wallace, KSBuilt 1966 · S/N 24-4650 N9163PMiller Richard Marc Trustee · Dana Point, CABuilt 1966 · S/N 24-4651 N9166PNewman Jeffrey M · Pauline, SCBuilt 1966 · S/N 24-4654 N9167PPegasus Unlimited LLC · Arroyo Grande, CABuilt 1966 · S/N 24-4655 N9169PPorter Christina · Cape Coral, FLS/N 24-4658 N916DSScout Aviation (De) LLC · Wilmington, DES/N 34-7970237 N9170PP&S Aviation LLC · White Rock, NMBuilt 1967 · S/N 24-4659 N9171PMckim Thomas F · Winston Salem, NCBuilt 1967 · S/N 24-4660 N9172PSale Reported · Henderson, NVSale reportedBuilt 1967 · S/N 24-4661 N9175SMarshall Adam A · Fremont, NEBuilt 1967 · S/N 24-4664 N9175ZMoeckel John H · North Venice, FLBuilt 1989 · S/N 2803003 N9176PWalter Richard · Hampshire, ILBuilt 1967 · S/N 24-4665 N9177PCochran Charles M III · Terre Haute, INBuilt 1967 · S/N 24-4666 N9178PCarnes Harley · Ocean, NJBuilt 1967 · S/N 24-4668 N9180DSan Souci Holdings LLC · Reisterstown, MDS/N 2837014 N9180HPiper Aircraft Inc · Vero Beach, FLS/N 2837015 N9180PHughes Travis · Willow Park, TXBuilt 1967 · S/N 24-4670 N9182PMonske Nicholas · Austin, TXS/N 24-4672 N9183WAerolina Inc · Hendersonville, NCBuilt 1989 · S/N 2837024 N9184XContinental Title Trust LLC Trustee · Wichita, KSBuilt 1966 · S/N 30-1041 N9187PJapundza Bob · Kokomo, INFirst renewal noticeS/N 24-4677 N9188PRogermoser Hanspeter · Summerville, SCBuilt 1967 · S/N 24-4678 N9189PThom Transport LLC · Marlette, MIBuilt 1967 · S/N 24-4680 N918YInternational Air Services Inc Trustee · Carson City, NVBuilt 1965 · S/N 30736 N9190PGreen Mark S · Ocala, FLBuilt 1967 · S/N 24-4683 N9191ECatlin Aviation Co · Okla City, OKRegistration revokedBuilt 1959 · S/N 241538 N9193PDean Aaron · Norwich, NYBuilt 1967 · S/N 24-4686 N9195PHarstine Lucene May · Claypool, INBuilt 1967 · S/N 24-4688 N9196PHarris Michael · Pointblank, TXBuilt 1967 · S/N 24-4689 N9197PHardin County Aviation LLC · Kountze, TXBuilt 1967 · S/N 24-4690 N9198PBarna George · Castleton, NYBuilt 1967 · S/N 24-4692 N919BSZimin Randolph L · South Naknek, AKBuilt 1976 · S/N 32R-7680180 N919WAMatteo Properties Inc · Wickliffe, OHBuilt 1980 · S/N 34-8070147 N91BRRegistration Pending · South Boston, VARegistration pendingBuilt 1965 · S/N 24-4326 N91KTBrotherson Travis C · Holstein, IABuilt 1978 · S/N 34-7870387 N91RGM&M Aviation LLC · Pelzer, SCBuilt 1958 · S/N 24-115 N91XCFitzgerald David R · Canton, OHBuilt 1971 · S/N 39-90 N9200PWings & Wheels Lease Of Central Nebraska LLC · Broken Bow, NEBuilt 1967 · S/N 24-4693 N9201KGadamic LLC · Fresno, CABuilt 1976 · S/N 28R-7635224 N9203KJoseph L Catania Dvm Pc · Alturas, CABuilt 1976 · S/N 28R-7635225 N9205KLancelite LLC · Corvallis, ORBuilt 1976 · S/N 32R-7680195 N9205PDt Pralle Enterprise Inc · Hampton, IAS/N 24-4700 N9207PWissler John H · Tenino, WABuilt 1967 · S/N 24-4702 N9211PBordeleau Michael V · Bridport, VTS/N 24-4706 N9212PHapka Leon J · Halma, MNFirst renewal noticeBuilt 1967 · S/N 24-4707 N9216PWilliams Dayre · Red Cloud, NEBuilt 1967 · S/N 24-4712 N9217PGruber Joachim R · Elizabethtown, KYFirst renewal noticeBuilt 1967 · S/N 24-4713 N9219PChrastka Keith · San Angelo, TXBuilt 1967 · S/N 24-4715

Back to AD 97-01-01 R1