Registered aircraft · 54,842

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-13') 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-13') 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-13')
    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-13')
  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-13')
  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-13')
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.

N101CANorton Energy Drilling LLC · Lubbock, TXS/N 425-0142 N101CGGrant Aviation Inc · Anchorage, AKBuilt 2015 · S/N 208B5191 N101CWAtlanta Technical College · Atlanta, GABuilt 1972 · S/N 177RG0290 N101DPStancy Marc A · Crystal Lake, ILBuilt 1967 · S/N 15067860 N101EEAlaskan Aerial Photography LLC · Anchorage, AKBuilt 1982 · S/N U20606602 N101FAStiletto Beaver Touchdown LLC · Evanston, ILS/N 15072843 N101FLElsing Germain J · Rushmore, MNBuilt 1970 · S/N 15071541 N101GHSan Diego Community College District · San Diego, CAS/N 18260875 N101HLPapoose Air II LLC · Wilmington, DEBuilt 1981 · S/N 425-0056 N101JHHi-Per Aviation Inc · Arroyo Grande, CABuilt 1972 · S/N 21059759 N101KSWright Kenneth D · Benton, ARBuilt 1974 · S/N 17263095 N101KTBryan Jerry E · Kathleen, GABuilt 1978 · S/N 18266264 N101LJGrenier Garret P · Anchorage, AKBuilt 1976 · S/N 17267273 N101MBGearin Chad T · Portland, ORBuilt 1960 · S/N 56537 N101MEIbs America Corp · Wilmington, DEBuilt 1969 · S/N 401A0130 N101MJRose Daniel · Cold Spring, NYBuilt 1974 · S/N A1500528 N101MTAllman Air LLC · Blackstone, VABuilt 1969 · S/N P20600626 N101PQValiair Limited Company Trustee · Casper, WYBuilt 1962 · S/N 21057932 N101PSJtech Solutions Inc · San Ramon, CABuilt 1982 · S/N 4250108 N101RGTree Air LLC · Vero Beach, FLBuilt 1967 · S/N 18258526 N101RKBlake James R · Marion, LABuilt 1972 · S/N 17261166 N101RSWillfish LLC · Vero Beach, FLBuilt 2016 · S/N 208B5289 N101SPHawkes Clark · Gillsville, GABuilt 1986 · S/N 18268562 N101TAHatch Hyrum G · Gilbert, AZBuilt 1977 · S/N 421C0331 N101TCTcm Flying Club Inc · Mobile, ALBuilt 1968 · S/N 18259330 N101TNHillsborough County Sheriffs Office · Tampa, FLS/N 20800587 N101USUsaeroflight LLC · Greenville, SCBuilt 1972 · S/N 17260922 N101UTRudd James M · Lake Jackson, TXBuilt 1971 · S/N 17259900 N101WPScc Associates Ltd · Wilmington, DEBuilt 1975 · S/N 18264220 N101WSKarnick Mark C · Mesa, AZBuilt 1971 · S/N 17260218 N101XWJoby Aero Inc · Santa Cruz, CABuilt 1993 · S/N 208B0382 N10205Thorndal John J · Tucson, AZBuilt 1973 · S/N 15074818 N10207Sillinger Daniel E · Covington, LABuilt 1973 · S/N 15074819 N10208Ekstrum Eric · Mound House, NVBuilt 1973 · S/N 15074820 N1020MWinner Philip · Houston, TXBuilt 1975 · S/N 18264208 N1020VCraig Air Inc · Wasilla, AKBuilt 1974 · S/N U20602404 N10213Sparks Tom · Palestine, ILBuilt 1975 · S/N 17702317 N1021CRiener Clinton G · Cottonwood, IDBuilt 1966 · S/N 18257409 N1021MMcconnell Frank V Jr · Woodstock, GABuilt 1969 · S/N 15070991 N1022FGoodfellow Malcolm D · Seattle, WABuilt 1975 · S/N 18502690 N1022MHilton David L · Shreveport, LABuilt 1975 · S/N 18264209 N1023BLeguia Augusto A · Kathleen, GAS/N 28524 N1023FWinter Karl · Litchfield Park, AZBuilt 1975 · S/N 18502691 N1024Calgonaire LLC · Seminole, TXS/N 57425 N10242Alexander Holding Services Inc · Newark, DEFirst renewal noticeBuilt 1972 · S/N 21059704 N1024MEdwards Chris R · Meadow Vista, CABuilt 1975 · S/N 18264210 N10255Zook Lester R · North East, PABuilt 1973 · S/N 15074825 N1025MSupina Robert P · Richmond, TXBuilt 1975 · S/N 18264211 N1025VAviation Partners LLC · Highlands Ranch, COBuilt 1976 · S/N R1722086 N1026MStinar Gary F · Lakeville, MNBuilt 1970 · S/N 17259406

Back to AD 97-01-13