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.

N8131PCheak Alan S · Peachtree City, GABuilt 1962 · S/N 24-3384 N8132PMiller Lawrence A · Winthrop Harbor, ILBuilt 1963 · S/N 24-3385 N8132YJessen Eric Carl · La Luz, NMBuilt 1966 · S/N 30-1244 N8133PChristy H Spencer · Wetumpka, ALBuilt 1963 · S/N 24-3386 N8133YLeaders Bob O · Clear Lake, MNBuilt 1966 · S/N 30-1245 N8134KTory Hill Innovations LLC · Stillwater, MNBuilt 1979 · S/N 34-8070055 N8134SThwaites Dwayne · Elizabeth City, NCS/N 34-8070056 N8136PCragg Gordon E · Georgetown, TXBuilt 1963 · S/N 24-3389 N8137YSale Reported · Chisago City, MNSale reportedBuilt 1966 · S/N 30-1248 N8138PFrank Castillo Dds Inc · San Jose, CABuilt 1963 · S/N 24-3392 N8139YBuchanan Jason A · Meridian, IDBuilt 1966 · S/N 30-1250 N813DLBoys Out Flying LLC · Stevens Point, WIBuilt 1977 · S/N 32R-7880003 N813NDPlane Nonsense Inc · Middletown, DEBuilt 1989 · S/N 2837044 N8140EProppe Karl H · Needham, MABuilt 1982 · S/N 28R-8218012 N8143P8143 Leasing LLC · Manassas, VABuilt 1963 · S/N 24-3396 N8143YTennave LLC · Dublin, OHBuilt 1966 · S/N 30-1254 N8145PRegistered aircraftBuilt 1963 · S/N 24-3398 N8147DHamic Lonny T DBA · Powell, WYBuilt 1979 · S/N 34-8070113 N8147ETouretzky David S · West Mifflin, PABuilt 1979 · S/N 34-8070114 N8147FHubble Timothy S · Lake Alfred, FLS/N 34-8070117 N8147PHinson Jerry W · Nederland, TXBuilt 1963 · S/N 24-3400 N8147YRietz Douglas W · Walla Walla, WABuilt 1966 · S/N 30-1259 N814NDPlane Nonsense Inc · Middletown, DEBuilt 1989 · S/N 2837045 N814RCCamelot Express LLC · Naples, FLBuilt 1966 · S/N 301202 N8150YBok Hans · North Dartmouth, MAFirst renewal noticeBuilt 1966 · S/N 30-1263 N81514Soar Above Flight Solutions LLC · Englewood, TNS/N 30-1264 N8151P63 Comanche LLC · Las Vegas, NVBuilt 1963 · S/N 24-3406 N8154YRawson Aviation LLC · Collinsville, OKBuilt 1966 · S/N 30-1267 N8155PSanders Tyler George · Tehachapi, CABuilt 1963 · S/N 24-3410 N8155YTalley John T · Clifton, TXS/N 30-1269 N8156KJrm Aviation LLC · Saint Petersburg, FLS/N 34-8070133 N8156PVectors West LLC · Coeur D Alene, IDBuilt 1963 · S/N 24-3411 N8156QFitch Douglas A · Sheffield Village, OHBuilt 1980 · S/N 34-8070136 N8157YSchmidt Zachary P · Raleigh, NCBuilt 1966 · S/N 30-1270 N8159PRegistration Pending · Tucson, AZRegistration pendingBuilt 1963 · S/N 24-3414 N815TAS3 Air Aviation LLC · Henderson, NVBuilt 1976 · S/N 32R-7680356 N8160PSouth Texas Weather Modification Association · Pleasanton, TXBuilt 1963 · S/N 24-3415 N8164PHobbs Phillip E · Matthews, NCBuilt 1963 · S/N 24-3419 N8164YBrewer Steven G · Laconia, NHBuilt 1966 · S/N 30-1277 N8165PJohnson Warford B II · Ozark, MOBuilt 1963 · S/N 24-3420 N8165YCunningham Aviation LLC · Jackson, MSFirst renewal noticeBuilt 1980 · S/N 34-8070142 N8166JTodd David A · Redmond, WABuilt 1980 · S/N 34-8070146 N8166UEli Air Center Inc · Parkland, FLBuilt 1980 · S/N 34-8070173 N8167PDiehl Matthew · Elk River, MNBuilt 1963 · S/N 24-3423 N8168PSchrump Donald R · Putnam, CTBuilt 1963 · S/N 24-3424 N8169PLudlow Brent G · Murray, UTBuilt 1963 · S/N 24-3425 N8170PLock Haven Aircraft Sales · Lock Haven, PABuilt 1963 · S/N 24-3426 N8172YKline John C · Wolcottville, INBuilt 1966 · S/N 30-1286 N8173YAltitude Aviation Group LLC · Kissimmee, FLS/N 30-1287 N8174HBeitins Mark · Rockville, MDBuilt 1980 · S/N 34-8070155

Back to AD 97-01-01 R1