Skip to content

Registered aircraft · 149

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:81-06-05-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:81-06-05-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:81-06-05-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:81-06-05-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:81-06-05-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:81-06-05-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.

N101AEAir Evac Ems Inc · O Fallon, MOBuilt 1980 · S/N 45454 N103AEAir Evac Ems Inc · O Fallon, MOBuilt 1981 · S/N 45597 N106AEAir Evac Ems Inc · O Fallon, MOBuilt 1981 · S/N 45566 N1075WSan Juan Aviation LLC · Wilmington, DEBuilt 1980 · S/N 45377 N1075YShoreline Aircraft Leasing LLC · Lewes, DEBuilt 1980 · S/N 45378 N1078NBank Of Utah Trustee · Salt Lake City, UTBuilt 1980 · S/N 45389 N1081KMarks Aviation Group LLC · Lafayette, LABuilt 1980 · S/N 45407 N1085TAspen Helicopters Inc · Oxnard, CABuilt 1980 · S/N 45376 N108AEAir Evac Ems Inc · Ofallon, MOBuilt 1981 · S/N 45730 N110LTLt Aviation LLC · Louisa, KYBuilt 1981 · S/N 45676 N113AEAir Evac Ems Inc · O Fallon, MOS/N 45371 N1171Agricultural Air Services LLC · Jupiter, FLBuilt 1979 · S/N 45234 N118AEAir Evac Ems Inc · O Fallon, MOBuilt 1981 · S/N 45724 N123HPSouthwest Heliservices LLC · Mesa, AZBuilt 1980 · S/N 45394 N12AEAir Evac Ems Inc · O Fallon, MOBuilt 1981 · S/N 45649 N130AEAir Evac Ems Inc · O Fallon, MOBuilt 1980 · S/N 45467 N132AEAir Evac Ems Inc · O Fallon, MOBuilt 1980 · S/N 45491 N133AEAir Evac Ems Inc · O Fallon, MOBuilt 1979 · S/N 45280 N134AEAir Evac Ems Inc · O Fallon, MOBuilt 1981 · S/N 45593 N138AEAir Evac Ems Inc · O Fallon, MOBuilt 1983 · S/N 45782 N138DDDalton Aviation LLC · Bluffdale, UTBuilt 1979 · S/N 45199 N144TVAir Flite Inc · Shawnee, OKBuilt 1982 · S/N 45602 N14SJAlternative Energies Corp · Beaver Island, MIS/N 45564 N176AEAir Evac Ems Inc · Ofallon, MOBuilt 1979 · S/N 45224 N178PAOrlando Aircraft Sales LLC · Orlando, FLBuilt 1979 · S/N 45319 N192AEAir Evac Ems Inc · O Fallon, MOS/N 45660 N2009CMeridian Helicopters LLC · Broussard, LABuilt 1982 · S/N 45678 N20316Back Nine Aerial LLC · New Berlin, WIBuilt 1981 · S/N 45687 N206DRDel Rio Aviation Inc · Paso Robles, CAS/N 45180 N206GSBank Of Utah Trustee · Salt Lake City, UTBuilt 1982 · S/N 45760 N206LWStanislaus County Sheriffs Department · Modesto, CABuilt 1978 · S/N 45182 N206SLAv8-Orr Helicopter Services Inc · Hamilton, MTBuilt 1979 · S/N 45245 N206VCVentura County Sheriff'S Dept · Camarillo, CAS/N 45567 N206WLSummit Helicopters Inc · Salem, VABuilt 1980 · S/N 45513 N2070UAero-Tech Helicopters LLC · Kingstree, SCS/N 45706 N2072MOrlando Aircraft Sales LLC · Orlando, FLBuilt 1982 · S/N 45720 N20ZPatriot Aviation Inc · Greenville, DEBuilt 1982 · S/N 45334 N2122T22t Aero LLC · Hermosa Beach, CAS/N 45587 N2150MT&M Aviation Inc · Abbeville, LABuilt 1981 · S/N 45703 N225AEAir Evac Ems Inc · O Fallon, MOS/N 45577 N226SHScotts Helicopter Services Inc · Le Sueur, MNBuilt 1981 · S/N 45643 N228AEAvid Aviation Group Inc · Jupiter, FLBuilt 1981 · S/N 45697 N229AEAir Evac Ems Inc · O Fallon, MOS/N 45256 N22UKOas2 LLC · Orlando, FLBuilt 1980 · S/N 45435 N233BBTop Gun Precision Ag LLC · Skidmore, TXBuilt 1980 · S/N 45489 N239AEAir Evac Ems Inc · O Fallon, MOBuilt 1980 · S/N 45367 N249THTimberland Helicopters Inc · Ashland, ORBuilt 1980 · S/N 45459 N24AEAir Evac Ems Inc · O Fallon, MOBuilt 1981 · S/N 45646 N258AEAir Evac Ems Inc · O Fallon, MOBuilt 1980 · S/N 45578 N25BH25bh LLC · Lewes, DEBuilt 1979 · S/N 45336

Back to AD 81-06-05 R1