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.

N25GHJbi South Leasing LLC · Pembroke, NHBuilt 1982 · S/N 45755 N2611Jbi South Leasing LLC · Pembroke, NHBuilt 1980 · S/N 45417 N274AEAir Evac Ems Inc · O Fallon, MOBuilt 1983 · S/N 45762 N27694Orlando Aircraft Sales LLC · Orlando, FLS/N 45282 N27AEAir Evac Ems Inc · O Fallon, MOBuilt 1978 · S/N 45192 N283RLMarks Lloyd · Lafayette, LAS/N 45283 N291SEzell Holdings LLC · Tucson, AZS/N 45698 N292AEAir Evac Ems Inc · O Fallon, MOBuilt 1983 · S/N 45780 N296AEAir Evac Ems Inc · O Fallon, MOBuilt 1980 · S/N 45398 N299AEAir Evac Ems Inc · O Fallon, MOBuilt 1981 · S/N 45621 N303AENorth Wind Aviation LLC · Cottage Grove, ORBuilt 1979 · S/N 45348 N304CHPerfect Agreements Leasing · Trabuco Canyon, CAS/N 45388 N305CHGeco Inc · Wilmington, DES/N 45469 N306PHFinish Line Aviation LLC · Pembroke, NHS/N 45411 N311AEAir Evac Ems Inc · O Fallon, MOS/N 45572 N313DHRogers Helicopters Inc · Fresno, CABuilt 1981 · S/N 45630 N315AEAir Evac Ems Inc · O Fallon, MOBuilt 1980 · S/N 45482 N315MHCane Helicopter Services LLC · Franklin, LABuilt 1981 · S/N 45692 N316SPSan Juan Aviation LLC · Wilmington, DEBuilt 1983 · S/N 45768 N3173HAlabama Law Enforcement Agency · Montgomery, ALBuilt 1982 · S/N 45714 N3176LRiggs Bobby W · Lake Mary, FLBuilt 1983 · S/N 45648 N3184PMarks Lloyd · Lafayette, LAS/N 45774 N3188PMarks Aviation Group LLC · Lafayette, LABuilt 1983 · S/N 45778 N3190PVeturis David · Lake Forest, CABuilt 1983 · S/N 45779 N32AEAir Evac Ems Inc · O Fallon, MOBuilt 1979 · S/N 45327 N333EROrlando Aircraft Sales LLC · Orlando, FLBuilt 1979 · S/N 45203 N337AEAir Evac Ems Inc · O Fallon, MOBuilt 1980 · S/N 45383 N34AETrinkle Aviation LLC · Kingsburg, CABuilt 1979 · S/N 45218 N38885Back Nine Aerial LLC · New Berlin, WIBuilt 1981 · S/N 45726 N388JCSweetwater Landing LLC · Helena, MTBuilt 1981 · S/N 45568 N3895DMonarch Enterprises Inc · Kirkland, WABuilt 1980 · S/N 45590 N38960Greystones Aviation Worldwide Inc · Dulles, VAS/N 45536 N38QHawkeye Helicopter LLC · Lyndon, KSBuilt 1980 · S/N 45364 N38THGlobal Aerials Inc · Pembroke Pines, FLS/N 45653 N393SSouthwest Heliservices LLC · Mesa, AZBuilt 1980 · S/N 45494 N395AEAir Evac Ems Inc · O Fallon, MOS/N 45551 N396RLMorris Equipment LLC · Yuma, AZBuilt 1980 · S/N 45-396 N397RLBank Of Utah Trustee · Salt Lake City, UTBuilt 1980 · S/N 45397 N39LRHornet LLC · Picayune, MSBuilt 1981 · S/N 45654 N406PWBank Of Utah Trustee · Salt Lake City, UTBuilt 1980 · S/N 45446 N412KKElkhorn Aviation Inc · Baker City, ORS/N 45277 N413TVTri Rotor Spray & Chemical · Ulysses, KSBuilt 1981 · S/N 45636 N4227EMonarch Enterprises Inc · Kirkland, WABuilt 1981 · S/N 45702 N429ZACoastal Air Service Inc · Panama City, FLBuilt 1980 · S/N 45375 N43AEAir Evac Ems Inc · O Fallon, MOBuilt 1978 · S/N 45187 N447JBJbi South Leasing LLC · Pembroke, NHBuilt 1980 · S/N 45415 N461RARanger Aviation Leasing LLC · Wilmington, DES/N 45461 N48AEAir Evac Ems Inc · O Fallon, MOBuilt 1980 · S/N 45562 N5000GTimberland Helicopters Inc · Ashland, ORBuilt 1978 · S/N 45163 N50046Orlando Aircraft Sales LLC · Orlando, FLBuilt 1978 · S/N 45173

Back to AD 81-06-05 R1