Registered aircraft · 52

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:96-18-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:96-18-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:96-18-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:96-18-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:96-18-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:96-18-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.

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 N138LWIsland Air Charters Inc · Ft Lauderdale, FLBuilt 1978 · S/N 138 N19WAMcphillips Flying Service Inc · St James, MIBuilt 1976 · S/N 524 N200MUIslander Holdings Ltd · Fort Lauderdale, FLBuilt 1971 · S/N 78 N209RGSr Aviation Inc · Sarasota, FLBuilt 1971 · S/N 209 N27MRRedemption Inc DBA · Kodiak, AKS/N 884 N296TAIslander Holdings Ltd · Fort Lauderdale, FLS/N 384 N297TAInternational Air Services Inc Trustee · Carson City, NVBuilt 1975 · S/N 741 N298TAIslander Holdings Ltd · Fort Lauderdale, FLBuilt 1974 · S/N 711 N324TAIslander Holdings Ltd · Fort Lauderdale, FLBuilt 1980 · S/N 892 N401WBNew England Airlines Inc · Westerly, RIBuilt 1969 · S/N 66 N403WBNew England Airlines Inc · Westerly, RIBuilt 1969 · S/N 46 N404WBNew England Airlines Inc · Westerly, RIBuilt 1977 · S/N 564 N406CWMcphillips Flying Service DBA · Charlevoix, MIBuilt 1980 · S/N 891 N409WBNew England Airlines Inc · Westerly, RIS/N 3008 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 N519LGSawtooth Flying Service Inc · Mccall, IDBuilt 1977 · S/N 2005 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 N706MCSt Bernard Parish Government · Chalmette, LABuilt 1980 · S/N 883 N779KSIsland Air Charters Inc · Ft Lauderdale, FLBuilt 1976 · S/N 779 N80KMMcphillips Flying Service Inc DBA · Beaver Island, MIBuilt 1969 · S/N 80 N821RRAir Charter Inc DBA · Culebra, PRBuilt 1973 · S/N 338 N863VLVieques Air Link · Vieques, PRBuilt 1979 · S/N 2019 N864VLVieques Air Link Inc · San Juan, PRBuilt 1974 · S/N 712 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 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 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

Back to AD 96-18-21