Skip to content

Registered aircraft · 366

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:84-12-01-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:84-12-01-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:84-12-01-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:84-12-01-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:84-12-01-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:84-12-01-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.

N100ATWestern Pacific Fisheries · Hermosa Beach, CABuilt 1980 · S/N 500718D N101CHTri-State Vegetation Management LLC · Vevay, INS/N 1000829D N102SUSignature Property Holdings LLC · Wilmington, DES/N 700736D N104SUSignature Property Holdings LLC · Wilmington, DEBuilt 1977 · S/N 670151D N105ACAgricultural Air Services LLC · Jupiter, FLBuilt 1978 · S/N 580316D N105SUSignature Property Holdings LLC · Wilmington, DEBuilt 1988 · S/N 800776D N106SUSignature Property Holdings LLC · Wilmington, DEBuilt 1981 · S/N 510954D N107SFDah Aircraft LLC · Georgetown, SCBuilt 1978 · S/N 1280405D N1088NTemsco Helicopters Inc · Ketchikan, AKBuilt 1980 · S/N 300679D N108ECHva Inc · Summersville, WVBuilt 1982 · S/N 811049D N108PPCity Of Pomona · Pomona, CABuilt 2008 · S/N 0578E N1091PTemsco Helicopters Inc · Ketchikan, AKBuilt 1980 · S/N 300683D N1091STemsco Helicopters Inc · Ketchikan, AKBuilt 1980 · S/N 300691D N1092LDel Rio Aviation Inc · Paso Robles, CAS/N 410940D N1095TState Of Montana · Helena, MTS/N 800769D N1097JSignature Property Holdings LLC · Wilmington, DEBuilt 1980 · S/N 900801D N109LBVertol Systems Company Inc · Destin, FLBuilt 1991 · S/N 0455E N1101NLindemann Drilling Company Inc · Archer City, TXBuilt 1981 · S/N 510960D N1102DAviation Advantage Inc · Tabor City, NCBuilt 1980 · S/N 900806D N1103LAviation Advantage Inc · Tabor City, NCBuilt 1980 · S/N 1000812D N1103VGulf Helicopters LLC · Santa Fe, TXS/N 1000823D N11054Winco Inc · Aurora, ORBuilt 1981 · S/N 310910D N11056Northwest Helicopters I Inc · Olympia, WABuilt 1981 · S/N 310905D N1106GSenninger Thomas P · Clermont, FLBuilt 1981 · S/N 510955D N1106ZEnright Miles · Ketchikan, AKBuilt 1981 · S/N 210900D N1107NCairns Dave DBA · Lemon Cove, CABuilt 1981 · S/N 210902D N1107PTemsco Helicopters Inc · Ketchikan, AKBuilt 1981 · S/N 210897D N1107TAviation Advantage Inc · Tabor City, NCBuilt 1981 · S/N 210898D N11082Vertical Corp · Kalispell, MTBuilt 1980 · S/N 1100845D N1110QAviation Advantage Inc · Tabor City, NCBuilt 1981 · S/N 611011D N111ADSvp LLC · Missoula, MTBuilt 1980 · S/N 400704D N112ASOlympic Jet Inc · Olympia, WABuilt 1980 · S/N 900808D N114HDWindward Aviation Inc · Puunene, HIBuilt 1978 · S/N 280261D N115HDLaroche Aviation Services LLC · Bellaire, OHBuilt 1981 · S/N 711020D N115SUSignature Property Holdings LLC · Wilmington, DEBuilt 2021 · S/N 110868D N124PDH & O Helicopters Inc Trustee · Wilmington, DEBuilt 1992 · S/N 0502E N125KWAurora Aviation Services Inc · Delta Junction, AKBuilt 1989 · S/N 0336E N126KWHlh Leasing LLC · Wilmington, DEBuilt 1991 · S/N 0489E N12THHarding Tim · Bryan, TXS/N 0224E N131ALQuicksilver Air Inc · Fairbanks, AKBuilt 1977 · S/N 1170230D N131NWEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1982 · S/N 1131D N138TXAir2 LLC · Blountville, TNBuilt 1979 · S/N 1290646D N13KJCarlston Carl Vaughn · Murray, UTBuilt 1991 · S/N 0444E N145ALQuicksilver Air Inc · Fairbanks, AKBuilt 1980 · S/N 1200856D N151JPFarmar Peter D · San Angelo, TXBuilt 1978 · S/N 480301D N155NRState Of Minnesota · Grand Rapids, MNBuilt 2015 · S/N 0623E N1578FHeliservice LLC · Wilmington, DEBuilt 1981 · S/N 610957D N15THHeliservice LLC · Wilmington, DEBuilt 2003 · S/N 0564E N16002Commonweath Of Massachusetts · East Boston, MAS/N 0194E N1602LSaxton Helicopter Leasing LLC · Plymouth, MIS/N 0225E

Back to AD 84-12-01 R1