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.

N6888JMovable Air LLC · Oldsmar, FLBuilt 1976 · S/N 32R-7680380 N6888PKempf Douglas A · La Center, WABuilt 1960 · S/N 24-2025 N688BGJones William E · Birmingham, ALBuilt 1969 · S/N 28R-35023 N688MBHill Frank G · Navarre, FLBuilt 1965 · S/N 24-4231 N688TBBiggar Stephen R · Jackson, NJBuilt 1977 · S/N 28R-7803054 N6890FKueser Brian · Chanute, KSBuilt 1976 · S/N 34-7770048 N6890PMarble Jere D · Dayton, NVBuilt 1960 · S/N 24-2027 N6891PWoods Eric V · Fort Washington, MDBuilt 1960 · S/N 24-2028 N6895PDavis Jack J · Rifle, COBuilt 1960 · S/N 24-2029 N6896PHwang Andrew S · Emeryville, CABuilt 1960 · S/N 24-2030 N6898PWeigle Alan B · Seward, NEBuilt 1960 · S/N 24-2032 N68AH740 Assoc Inc · Wilmington, DEBuilt 1968 · S/N 30-1685 N68CNEichten Steve G · Colleyville, TXBuilt 1969 · S/N 28R-35388 N68GPSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1967 · S/N 301656 N68JALost Aviators LLC · Durant, OKBuilt 2001 · S/N 2844057 N68JBOtto Pilot LLC · Everett, WABuilt 1963 · S/N 24-3531 N68JYHowell Jon · Texarkana, ARBuilt 1968 · S/N 28R-30850 N68KSeymour Robin · Woodland Hills, CABuilt 1976 · S/N 32R-7680227 N68KSFreedom Aviation Enterprise LLC · Salina, KSBuilt 1977 · S/N 34-7770252 N68LRMs Aero Inc · Lakeville, OHBuilt 1966 · S/N 30-1000 N68SCBridges Lee P · Smithville, TNBuilt 1964 · S/N 30-633 N68XLsk Aviation Corp · Wilmington, DEBuilt 1963 · S/N 30-238 N6900PMyer Charles G · Forest Lake, MNBuilt 1960 · S/N 24-2034 N6903PStack Gregory R · Aurora, COBuilt 1960 · S/N 242037 N6905JDouble Delta Sierra LLC · Bristol, CTBuilt 1976 · S/N 28R-7635359 N6905PMampel Gregory J · New Port Richey, FLBuilt 1960 · S/N 24-2039 N6905ZZellers And Smith Enterprises LLC · Flowood, MSBuilt 1968 · S/N 28R30649 N6906JBas Part Sales LLC · Greeley, COBuilt 1976 · S/N 32R-7680383 N6906PKapeller James A · Wickenburg, AZFirst renewal noticeBuilt 1960 · S/N 24-2040 N6907JFisher Bradley J · Bryant, INBuilt 1976 · S/N 32R-7680384 N6907PHolbein Mark A · Freeport, PAS/N 24-2041 N6909PWest Texas Weather Modification Association · San Angelo, TXBuilt 1960 · S/N 24-2043 N6912PAnzaldua Johnny J · Midland, TXFirst renewal noticeBuilt 1960 · S/N 24-2046 N6919PMunroe Consulting · Ocala, FLBuilt 1962 · S/N 24-3143 N691RPRegistration Pending · Mount Holly, VTRegistration pending, canceledBuilt 1969 · S/N 28R-35019 N6920PStanley Travis Navar · Dundee, OHBuilt 1960 · S/N 24-2054 N6923PLopez Ruben Arellano · Nogales, AZS/N 24-2057 N6924PLauderback Lee L · Fort Collins, COBuilt 1960 · S/N 24-2058 N6928POwen Colin Jc · College Station, TXBuilt 1960 · S/N 24-2062 N6932JRamonetta Vince · Westbrook, CTS/N 28R-7635362 N6932PMartenson Matthew J · Elgin, SCBuilt 1960 · S/N 24-2066 N6933PGeorghiou Sophia B · San Diego, CABuilt 1960 · S/N 24-2067 N6934JCopaair Maintenance Services Inc · Indiantown, FLBuilt 1976 · S/N 32R-7680389 N6934PChapman William R · Monroe, GABuilt 1960 · S/N 24-2068 N6938PSpero Robert C · Kent, WABuilt 1960 · S/N 24-2072 N6940FRebel Ranch LLC · Glenwood, ARBuilt 1976 · S/N 32R-7780050 N6942PPikes Peak Fliers At Meadowlake Airport LLC · Colorado Springs, COFirst renewal noticeBuilt 1960 · S/N 24-2077 N6944JJhap LLC · Hubbard, OHBuilt 1976 · S/N 28R-7635364 N6945FEuroaviation Inc Trustee · KematenBuilt 1977 · S/N 34-7770049 N6945JK&B Properties LLC · Lexington, SCBuilt 1976 · S/N 32R-7680391

Back to AD 97-01-01 R1