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

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-10-06-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-10-06-R1') 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:83-10-06-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-10-06-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.

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-10-06-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-10-06-R1')
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 N117MCParish Of East Baton Rouge · Baton Rouge, LABuilt 1988 · S/N 2178 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 N2119VG & S Aviation · Donnelly, IDBuilt 1981 · S/N 2105 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 N345CPCat Aviation LLC · Doral, FLBuilt 1991 · S/N 2244 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 N510BNHyannis Air Service Inc DBA · Hyannis, MABuilt 1991 · S/N 2239 N519LGSawtooth Flying Service Inc · Mccall, IDBuilt 1977 · S/N 2005 N520BNHyannis Air Service Inc · Hyannis, MABuilt 1991 · S/N 2240 N530BNHyannis Air Service DBA · Hyannis, MABuilt 1989 · S/N 2209 N540BNHyannis Air Service Inc D/B/A · Hyannis, MABuilt 1990 · S/N 2207 N55JAOberman Mark · Camarillo, CABuilt 1971 · S/N 295 N570BNHyannis Air Service Inc · Hyannis, MABuilt 1985 · S/N 2175 N606NTGimli Son LLC · Fort Lauderdale, FLBuilt 1972 · S/N 653 N6561BSpirit Air Inc · Salmon, IDBuilt 1976 · S/N 520 N663VLVieques Air Link Inc · Vieques, PRS/N 2110 N678CCIslander Cc LLC · Doral, FLBuilt 1980 · S/N 858 N706MCSt Bernard Parish Government · Chalmette, LABuilt 1980 · S/N 883 N70ASInternational Air Services Inc Trustee · Carson City, NVBuilt 2019 · S/N 2314 N779KSIsland Air Charters Inc · Ft Lauderdale, FLBuilt 1976 · S/N 779 N801SASpirit Air Inc · Salmon, IDBuilt 1979 · S/N 596 N802SASpirit Air Inc · Salmon, IDBuilt 1982 · S/N 2107 N80KMMcphillips Flying Service Inc DBA · Beaver Island, MIBuilt 1969 · S/N 80 N821RRAir Charter Inc DBA · Culebra, PRBuilt 1973 · S/N 338 N856BCGlobal Aircraft Trust Inc Trustee · Cheyenne, WYS/N C2171 N861VLVieques Air Link Inc · San Juan, PRBuilt 1984 · S/N 2155 N863VLVieques Air Link · Vieques, PRBuilt 1979 · S/N 2019 N864VLVieques Air Link Inc · San Juan, PRBuilt 1974 · S/N 712 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

Back to AD 83-10-06 R1