OpenAirDocs.org
AD 83-07-12 R1

Registered aircraft · 71

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
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:83-07-12-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:83-07-12-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.

N881GLActualized Business Solutions Inc DBA · California, MDBuilt 1968 · S/N 84N901GDAir Charter Inc DBA · Culebra, PRS/N 855N903GDAir Charter Inc DBA · Culebra, PRS/N 625N904GDAir Charter Inc DBA · Culebra, PRBuilt 1982 · S/N 2128N905GDAir Charter Inc DBA · Culebra, PRBuilt 1973 · S/N 339N906GDAir Charter Inc DBA · Culebra, PRBuilt 1979 · S/N 847N907GDAir Charter Inc DBA · Culebra, PRBuilt 1973 · S/N 340N907VLBlue Waters Air Charters LLC · San Juan, PRBuilt 1973 · S/N 343N908GDCorpus Terra Investments LLC · Hialeah, FLBuilt 1988 · S/N 2040N908VLBlue Waters Air Charters LLC · San Juan, PRBuilt 1984 · S/N 2187N909VLBlue Waters Air Charters LLC · San Juan, PRBuilt 1978 · S/N 895N910VLBlue Waters Air Chaters LLC · San Juan, PRBuilt 1969 · S/N 058N913GDAir Charter Inc DBA · Culebra, PRBuilt 1970 · S/N 198N917GDAir Charter Inc DBA · Culebra, PRBuilt 1976 · S/N 789N920GDAir Charter Inc DBA · Culebra, PRBuilt 1979 · S/N 1044N921GDAir Charter Inc DBA · Culebra, PRBuilt 1974 · S/N 420N928MJPlane Sales & Leasing LLC · Kalispell, MTS/N 1040N949PWMcphillips Flying Service Inc DBA · Beaver Island, MIBuilt 1970 · S/N 121N958KMEast Baton Rouge Parish Mosquito · Baton Rouge, LABuilt 1976 · S/N 498N95BNMcphillips Flying Service Inc · Charlevoix, MIBuilt 1969 · S/N 95N989YGBn Aerospace Sales Inc Trustee · Wilmington, DES/N 2279
Back to AD 83-07-12 R1