Registered aircraft · 27

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

N101NEDarby Flying Corp · Homestead, FLBuilt 1973 · S/N 201 N121DWFlight World Inc · San Juan, PRBuilt 1972 · S/N 312 N131JLIslander Holdings Ltd · Fort Lauderdale, FLBuilt 1970 · S/N 225 N137MWMcphillips Flying Service Inc DBA · Beaver Island, MIBuilt 1970 · S/N 137 N19WAMcphillips Flying Service Inc · St James, MIBuilt 1976 · S/N 524 N209RGSr Aviation Inc · Sarasota, FLBuilt 1971 · S/N 209 N296TAIslander Holdings Ltd · Fort Lauderdale, FLS/N 384 N401WBNew England Airlines Inc · Westerly, RIBuilt 1969 · S/N 66 N442SGriffing Flying Service Inc · Port Clinton, OHBuilt 1976 · S/N 770 N4438Spirit Air Inc · Salmon, IDBuilt 1976 · S/N 766 N50693Griffing Flying Service Inc · Port Clinton, OHBuilt 1978 · S/N 828 N55JAOberman Mark · Camarillo, CABuilt 1971 · S/N 295 N606NTGimli Son LLC · Fort Lauderdale, FLBuilt 1972 · S/N 653 N6561BSpirit Air Inc · Salmon, IDBuilt 1976 · S/N 520 N80KMMcphillips Flying Service Inc DBA · Beaver Island, MIBuilt 1969 · S/N 80 N821RRAir Charter Inc DBA · Culebra, PRBuilt 1973 · S/N 338 N864VLVieques Air Link Inc · San Juan, PRBuilt 1974 · S/N 712 N866JAMcphillips Flying Service Inc · Beaver Island, MIBuilt 1970 · S/N 185 N903GDAir Charter Inc DBA · Culebra, PRS/N 625 N905GDAir Charter Inc DBA · Culebra, PRBuilt 1973 · S/N 339 N907VLBlue Waters Air Charters LLC · San Juan, PRBuilt 1973 · S/N 343 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 N921GDAir Charter Inc DBA · Culebra, PRBuilt 1974 · S/N 420 N958KMEast Baton Rouge Parish Mosquito · Baton Rouge, LABuilt 1976 · S/N 498 N95BNMcphillips Flying Service Inc · Charlevoix, MIBuilt 1969 · S/N 95

Back to AD 76-13-12