Registered aircraft · 76

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:2002-01-11') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-01-11') 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:2002-01-11')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-01-11')
  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:2002-01-11')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-01-11')
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.

N865VLSale Reported · San Juan, PRSale reportedBuilt 1987 · S/N 2125 N866JAMcphillips Flying Service Inc · Beaver Island, MIBuilt 1970 · S/N 185 N869VLVieques Air Link Inc · Vieques, PRBuilt 1983 · S/N 1048 N880GLNew England Airlines Inc · Westerly, RIS/N 2020 N881GLActualized Business Solutions Inc DBA · California, MDBuilt 1968 · S/N 84 N901GDAir Charter Inc DBA · Culebra, PRS/N 855 N903GDAir Charter Inc DBA · Culebra, PRS/N 625 N904GDAir Charter Inc DBA · Culebra, PRBuilt 1982 · S/N 2128 N905GDAir Charter Inc DBA · Culebra, PRBuilt 1973 · S/N 339 N906GDAir Charter Inc DBA · Culebra, PRBuilt 1979 · S/N 847 N907GDAir Charter Inc DBA · Culebra, PRBuilt 1973 · S/N 340 N907VLBlue Waters Air Charters LLC · San Juan, PRBuilt 1973 · S/N 343 N908GDCorpus Terra Investments LLC · Hialeah, FLBuilt 1988 · S/N 2040 N908VLBlue Waters Air Charters LLC · San Juan, PRBuilt 1984 · S/N 2187 N909VLBlue Waters Air Charters LLC · San Juan, PRBuilt 1978 · S/N 895 N910VLBlue Waters Air Chaters LLC · San Juan, PRBuilt 1969 · S/N 058 N913GDAir Charter Inc DBA · Culebra, PRBuilt 1970 · S/N 198 N917GDAir Charter Inc DBA · Culebra, PRBuilt 1976 · S/N 789 N920GDAir Charter Inc DBA · Culebra, PRBuilt 1979 · S/N 1044 N921GDAir Charter Inc DBA · Culebra, PRBuilt 1974 · S/N 420 N928MJPlane Sales & Leasing LLC · Kalispell, MTS/N 1040 N949PWMcphillips Flying Service Inc DBA · Beaver Island, MIBuilt 1970 · S/N 121 N958KMEast Baton Rouge Parish Mosquito · Baton Rouge, LABuilt 1976 · S/N 498 N95BNMcphillips Flying Service Inc · Charlevoix, MIBuilt 1969 · S/N 95 N989YGBn Aerospace Sales Inc Trustee · Wilmington, DES/N 2279 N992ACLarge Michael M · Angeles CityNon-citizen corporation, flight hours not reportedBuilt 1982 · S/N C-3007

Back to AD 2002-01-11