Registered aircraft · 75

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

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 98-04-21