Skip to content

Registered aircraft · 54,837

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.

N1250SNew Oasis Market Inc · Blacksburg, VABuilt 1976 · S/N 18264819 N1250WScherff Lewis H Trustee · Inver Grove, MNBuilt 1964 · S/N 18051429 N1251Miltz Karl W · Black River, MIS/N 17254758 N12516Salganik Kallan Taylor · Waco, TXBuilt 1973 · S/N 17262033 N12517Huxster Robert H · Coatesville, PABuilt 1973 · S/N 17262034 N1251BJagow Charles Philip · Fairbanks, AKBuilt 1966 · S/N 18051756 N1251SPt Air LLC · Madison, WIBuilt 1976 · S/N 18264820 N1251UGrewal Amritpal S · Stockton, CAS/N 17266946 N1251YDurden Julian F Jr · Twin City, GABuilt 1962 · S/N 15059651 N12520Soucy Roland J · Pelham, NHBuilt 1973 · S/N 17262036 N12521Eagle Sky Patrol Inc · Deadwood, SDBuilt 1973 · S/N 17262037 N12525Tam United Logistic LLC · Toledo, OHBuilt 1973 · S/N 17262040 N12526Kull Joel W · Wadsworth, OHBuilt 1973 · S/N 17262041 N12527Air Carriage LLC · Chico, CABuilt 1973 · S/N 17262042 N12529Blue Goose Aviation Inc · Polson, MTBuilt 1973 · S/N 17262044 N1252GInternational Air Services Inc Trustee · Carson City, NVBuilt 1975 · S/N 414-0809 N1252MNyquist David · Boulder, COBuilt 1975 · S/N 18264259 N1252UGentry Aviation Holdings LLC · Olive Branch, MSBuilt 1976 · S/N 17266947 N12531Guardian Flight LLC · South Jordan, UTBuilt 1973 · S/N 17262046 N12537Ciuperger Vasile · Port Saint Lucie, FLBuilt 1973 · S/N 17262052 N1253QLibbyn The Dream Fishing Team LLC · Anchorage, AKS/N 18503473 N1253SHale Jeffrey D · Reno, NVBuilt 1976 · S/N 18264822 N12541High Flight Academy LLC · Allison Park, PABuilt 1973 · S/N 17262056 N12545Plane Nonsense Inc · Middletown, DEBuilt 1973 · S/N 17262060 N12546Hain Jerry A · Sahuarita, AZBuilt 1973 · S/N 17262061 N1254QWeber Joel A · Goddard, KSBuilt 1971 · S/N 15072554 N1254SStewart Donald K · Holbrook, MABuilt 1976 · S/N 18264823 N12550N12550 LLC · Greenville, MSBuilt 1973 · S/N 17262064 N12555Torre Gregory M · Verona, NJBuilt 1973 · S/N 17262068 N12556White William T · Louisville, OHBuilt 1973 · S/N 17262069 N12559Hampton Flying Services LLC · Portsmouth, NHBuilt 1973 · S/N 17262072 N1255CHaslett Lisa L · Vinita, OKBuilt 1977 · S/N 17702691 N1255MCammack Lockwood P · Mount Pleasant, TXFirst renewal noticeBuilt 1975 · S/N 18264261 N1255QDrucker Jonathan · Spring Hill, FLBuilt 1971 · S/N 15072555 N1255SSmith David J · Broken Arrow, OKBuilt 1979 · S/N R18201279 N1255UJohnson Shem E · Bonners Ferry, IDBuilt 1976 · S/N 17266950 N1255VHanson Lanny Lane · Polson, MTBuilt 1974 · S/N U20602540 N12560Hansen Mary L · Hay Springs, NEBuilt 1973 · S/N 17262073 N12561Popeszku Rudolf F · Waller, TXBuilt 1973 · S/N 17262074 N12562Weinreich Mark W · River Falls, WIBuilt 1973 · S/N 17262075 N1256CC177 Heavy LLC · Colfax, NCS/N 17702692 N1256PPlanemasters Ltd · West Chicago, ILBuilt 1996 · S/N 208B0564 N1256QRose Kerry D · Liberal, MOBuilt 1971 · S/N 15072556 N1256SBrant P Rouse Dds Plc · Tahlequah, OKBuilt 1976 · S/N 18264825 N1256UInverted Aviation LLC · Colorado Springs, COBuilt 1976 · S/N 17266951 N12571Dant Robert · West Chester, PABuilt 1973 · S/N 17262082 N12572Miles Alan R · Miami Beach, FLBuilt 1973 · S/N 17262083 N12573Plane N12573 Inc · Arlington, TNS/N 17262084 N12574Stockmans Service & Supply LLC · Rushville, NEBuilt 1973 · S/N 17262085 N12577Aftcloud Inc · Ontario, CABuilt 1973 · S/N 17262088

Back to AD 97-01-13