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.

N6260PLarson Jeffery A Trustee · Marysville, CABuilt 1959 · S/N 24-1368 N6261PRice Brent M · Onalaska, WABuilt 1959 · S/N 24-1369 N6263CKasallis Thomas G · Midlothian, TXBuilt 1978 · S/N 28R-7803215 N6263JMcclain Family Cellars Inc DBA · Irvine, CABuilt 1976 · S/N 32R-7680344 N6263PBerg Robert Martin · Madras, ORS/N 24-1371 N6267PFlyhigh LLC · Midlothian, VABuilt 1959 · S/N 24-1375 N626DWWings Of Freedom LLC · Big Bear Lake, CABuilt 1969 · S/N 30-1799 N626FMN626fm LLC · Brunswick, GABuilt 1979 · S/N 34-7970142 N626MVMandj LLC · Denver, COS/N 34-8170074 N626NRJones Robert D · Chestertown, MDBuilt 1970 · S/N 39-82 N626WAZarlenga And Seltzer Inc · Palmyra, PABuilt 1977 · S/N 34-7770303 N6271PMckee Kelvin K · Amelia Island, FLBuilt 1959 · S/N 24-1379 N6272PLearis Aviation LLC · Missoula, MTBuilt 1959 · S/N 24-1380 N6273JLance J Piper LLC · Green Bay, WIBuilt 1976 · S/N 32R-7680346 N6274PStowers Marc S · Lakewood, CABuilt 1959 · S/N 24-1383 N6275YAg Air Squadron Two LLC · St Joseph, ILBuilt 1969 · S/N 28R30079 N6278PPearson Phillip T · Sutherland, NEBuilt 1959 · S/N 24-1387 N627FDPacific Health Care Staffing Inc · Rancho Cucamonga, CABuilt 1978 · S/N 28R-7803187 N6281PTomorrow Horizons LLC · Urbana, OHBuilt 1959 · S/N 24-1390 N6282JLutter James L · Gann Valley, SDBuilt 1976 · S/N 32R-7680349 N6284PThomson William O · Simsbury, CTBuilt 1959 · S/N 24-1394 N6286PFuechsel Robert Marcus · Pocatello, IDBuilt 1959 · S/N 24-1396 N6288PKeenan Douglas P · Boulder Creek, CABuilt 1959 · S/N 24-1398 N6289JS K Bound LLC · Missoula, MTBuilt 1976 · S/N 28R-7635332 N6289PRegistered aircraftN-number assigned, not yet registeredS/N 24-1399 N6290JMclaen Family LLC · Queen Creek, AZBuilt 1976 · S/N 28R-7635333 N6293PAndersen Ted · Alamosa, COS/N 24-1403 N6298JPlane Fun Inc Tr Trustee · Snellville, GABuilt 1976 · S/N 28R-7635334 N6298PN6298p Inc · Okeechobee, FLBuilt 1959 · S/N 24-1278 N62FRRossi A F · Belmont, CABuilt 1965 · S/N 30-646 N62LPMagic City Aviators LLC · Hoover, ALBuilt 1977 · S/N 32R-7780375 N62MDRegistration Pending · Deland, FLRegistration pendingBuilt 1969 · S/N 28R-31073 N62MPSeeler John A · Bristol, NHS/N 34-7970437 N6301PDavid A Gowan · Templeton, CABuilt 1959 · S/N 24-1410 N6302PBarber Stephen R · Gainesville, GABuilt 1959 · S/N 24-1411 N6303PMarlette Ellen J · Cohasset, MAS/N 24-1413 N6304CHarben LLC · Albemarle, NCBuilt 1978 · S/N 28R-7837155 N6310PPopel John G Sr Trustee · Piqua, OHBuilt 1959 · S/N 24-1420 N6311CStarwood Holdings LLC · Seminole, FLBuilt 1978 · S/N 34-7870149 N6316PHitt Edward L · Statesboro, GAS/N 24-1426 N6317PYounhorsh Sales LLC · Wilmington, DEBuilt 1959 · S/N 24-1427 N6318PBlaha Karl F · Ocala, FLBuilt 1959 · S/N 24-1428 N6319PBedenbaugh Michael B · Lake City, FLBuilt 1959 · S/N 24-1429 N6320CHeme Flying LLC · Lewisville, NCBuilt 1978 · S/N 28R-7837157 N6325CCurtis Aviation LLC · Derby, KSBuilt 1978 · S/N 28R-7803220 N6327PSunspot Investment Corp · Marathon, FLBuilt 1959 · S/N 24-1436 N6329PKhan Adam Iqbal Ahmed · Sanger, TXBuilt 1959 · S/N 24-1438 N633TCHawkins Alan · Venice, FLFirst renewal noticeBuilt 1978 · S/N 34-7870328 N6343PMcgowan John B · Sunnyvale, CABuilt 1959 · S/N 24-1453 N6344PStanford Scott M · Spring Branch, TXBuilt 1959 · S/N 24-1454

Back to AD 97-01-01 R1