Skip to content

Registered aircraft · 498

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-01-02-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-01-02-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-01-02-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-01-02-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-01-02-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-01-02-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 N101SYRegistered aircraftBuilt 1970 · S/N 201374 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 N105UADown East Emergency Medicine Institute · Orono, MES/N 880723 N106SUSignature Property Holdings LLC · Wilmington, DEBuilt 1981 · S/N 510954D N107BNBig Boy Toys LLC · Mars, PAS/N 701438 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 N1133CSara Helicopters Inc · Wilmington, DEBuilt 1974 · S/N 940636S N114HDWindward Aviation Inc · Puunene, HIBuilt 1978 · S/N 280261D N115ECSara Helicopters Inc · Wilmington, DEBuilt 1971 · S/N 110292S N115HDLaroche Aviation Services LLC · Bellaire, OHBuilt 1981 · S/N 711020D N115SUSignature Property Holdings LLC · Wilmington, DEBuilt 2021 · S/N 110868D N119TTaylor Robert T · Chehalis, WABuilt 1976 · S/N 760844S N11ZXBig Bird Leasing Inc · Saint Peter, MNBuilt 1974 · S/N 640609S 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 N126SRDown East Emergency Medicine Institute · Orono, MES/N 1091299 N12964Sunflower Aero Inc · Atwood, KSS/N 570049 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

Back to AD 84-01-02 R1