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.

N1337LAviation Specialty Services LLC · Beaufort, NCBuilt 1977 · S/N 33701829 N1337QHarter Timothy W · Waterloo, ILBuilt 1971 · S/N 15072637 N1337YGaipa Aircraft Inc · Saint Joseph, MIBuilt 1961 · S/N 17249037 N13383Alpha Aviation-1 LLC · Naples, FLBuilt 1973 · S/N 17262718 N13384Premier Vacations LLC · Haines City, FLBuilt 1973 · S/N 17262719 N13386Crosswind Aviation Of Oklahoma LLC · Stillwater, OKS/N 17262720 N1338FVogel Auto Repair LLC · Palmer, NEBuilt 1966 · S/N 17254833 N1338GWings Air Charter LLC · Wisconsin Rapids, WIBuilt 1974 · S/N 310R0022 N1338UJstream Lc · Sheridan, WYBuilt 1965 · S/N 411-0105 N1338V38 Victor LLC · Port Clinton, OHBuilt 1976 · S/N R1722172 N1338YRegistered aircraftBuilt 1961 · S/N 17249038 N13391Brazos Valley Flight Services LLC · College Station, TXBuilt 1973 · S/N 17262723 N13394Ck Leasing Services LLC · Wilmington, DEBuilt 1973 · S/N 17262725 N13399Great Plains Spraying Inc · Colby, KSBuilt 1973 · S/N 17262729 N1339FFriedlander Edward R · Hattiesburg, MSBuilt 1966 · S/N 17254834 N1339GLyon Aviation Inc · Pittsfield, MABuilt 1974 · S/N 310R0023 N1339YMiller Henry C · Mckinney, TXS/N 17249039 N133AJAmerican Patrols Inc · Midland, TXBuilt 1986 · S/N 17276614 N133CWDeniro Corp · Hampton, NHBuilt 1978 · S/N 310R1260 N133DSHagopian Donald D · Van Nuys, CABuilt 1965 · S/N 18256837 N133NDHitch-Nel Partners LLC · Issaquah, WABuilt 1975 · S/N 33701669 N133PCGilco Distributors · Santa Rosa, CABuilt 1976 · S/N 340A0093 N133RFRandigo LLC · Wilmington, DEBuilt 2000 · S/N 208B0840 N133TSHunter Stephen Eugene · Grace, MSBuilt 1966 · S/N 18257883 N133VWAlpine Katmai LLC · Alpine, WYBuilt 1975 · S/N 18263927 N13400Opolka John G · Midlothian, TXBuilt 1973 · S/N 17262730 N13402Cartwright Edward N · Winterville, NCBuilt 1973 · S/N 17262731 N13404Kroner David S · Rock Creek, OHBuilt 1973 · S/N 17262733 N13405Kelley Aircraft LLC · Weyers Cave, VABuilt 1973 · S/N 17262734 N13406Shore Stephen A · Thurmond, NCS/N 17262735 N1340YStephens Christopher L · Kelso, WAS/N 17249040 N13411Leiss Todd J · Merritt Island, FLBuilt 1976 · S/N 17702419 N1341FDix Justin T · South Boston, VABuilt 1966 · S/N 17254836 N1341YLong Gary A · Lewisport, KYBuilt 1962 · S/N 17249041 N13426Sardeson Ronald L · Greenwood, NEBuilt 1973 · S/N 17262744 N13429Mercado Carlos · San Juan, PRBuilt 1973 · S/N 17262746 N1342FFriedman Peter Michael · Pleasant Hill, CABuilt 1966 · S/N 17254837 N1342GSpector Steven D · Glenview, ILBuilt 1974 · S/N 310R0026 N1342SFreeworld Aviation LLC · Dixon, ILBuilt 1976 · S/N 18264905 N13430Mjr Assoc LLC · Bend, ORBuilt 1976 · S/N 17702420 N13431Kelly William W · Springfield, ORBuilt 1973 · S/N 17262748 N13435Torres Debra A · El Paso, TXBuilt 1973 · S/N 17262749 N13437Dyberg Michael DBA · Mount Vernon, WABuilt 1973 · S/N 17262751 N1343SComalander Christopher R · Beaumont, TXBuilt 1976 · S/N 18264906 N13445Laurel Highlands Aeronautical Academy · Latrobe, PABuilt 1973 · S/N 17262756 N13447Vessichelli Ryan A · Virginia Beach, VABuilt 1973 · S/N 17262757 N1344UGrit Services LLC · Manila, ARBuilt 1962 · S/N 18254544 N13450Wilkes Flying Club Inc · Wilkesboro, NCBuilt 1973 · S/N 17262760 N13451Kostman Cody J · Bingham, NEBuilt 1973 · S/N 17262761 N13452Butler Shane M · Russellville, ARBuilt 1973 · S/N 17262762

Back to AD 97-01-13