Registered aircraft · 758

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:72-03-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-06') 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:72-03-06')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-06')
  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:72-03-06')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-06')
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.

N100LMHaddock Flying Service Inc · Salters, SCS/N 1583 N101ALRegistered aircraftBuilt 1980 · S/N U20605684 N101CHTri-State Vegetation Management LLC · Vevay, INS/N 1000829D N101DGSummit Helicopters Inc · Salem, VABuilt 1986 · S/N 3929 N101MZBohonis David C · North DeltaNon-citizen corporation, flight hours not reportedBuilt 1980 · S/N 5045 N102CGSale Reported · Surprise, AZSale reported, pending cancellationBuilt 1998 · S/N LNO85 N102UMTimberland Helicopters Inc · Ashland, ORBuilt 1981 · S/N 5075 N104HHHaddock Flying Service Inc · Salters, SCBuilt 1960 · S/N 2062 N105HHHaddock Flying Service Inc · Salters, SCS/N 1307 N105JDHavens Aviation LLC · Blacklick, OHBuilt 1973 · S/N 1105 N105LCCenterline Holdings Inc · Camden, DEBuilt 1988 · S/N S789 N105SUSignature Property Holdings LLC · Wilmington, DEBuilt 1988 · S/N 800776D N106AMJasons Helicopter Services LLC · New Prague, MNBuilt 1974 · S/N 1384 N106JCTrans Peco Aviation LLC · Fort Stockton, TXBuilt 1982 · S/N 3622 N1075WSan Juan Aviation LLC · Wilmington, DEBuilt 1980 · S/N 45377 N1076GHenderson Aviation Co · Junction City, ORBuilt 1979 · S/N 2831 N107GGCarbon River Helicopter Services LLC · Lexington, KYBuilt 1980 · S/N 2917 N107PHSouthern Helicopter Service Inc · Millington, TNBuilt 1979 · S/N 2789 N1081KMarks Aviation Group LLC · Lafayette, LABuilt 1980 · S/N 45407 N109CYO'Brien Derrick P · Middletown, DES/N 7351 N109DHHordon Kathleen R · Newburyport, MABuilt 1976 · S/N 57213 N109MMAirborne Leasing Inc · Sylmar, CABuilt 1985 · S/N 7279 N109PBBennedsen Rosa Fadia Gabriel · Aventura, FLBuilt 1985 · S/N 7344 N109USU S Helicopters Inc · Marshville, NCBuilt 1977 · S/N 2164 N109XPNational Test Pilot School · Mojave, CABuilt 1981 · S/N 7178 N10AJEl Aero Services LLC · Elko, NVBuilt 1980 · S/N 3169 N10JSSiegel Jerry S · Los Angeles, CAS/N 008 N10KXWhirly Leasing Inc · Richvale, CABuilt 1975 · S/N 1628 N10MYBoston Executive Helicopters LLC · Norwood, MABuilt 1991 · S/N 5500 N1103LAviation Advantage Inc · Tabor City, NCBuilt 1980 · S/N 1000812D N11056Northwest Helicopters I Inc · Olympia, WABuilt 1981 · S/N 310905D N110GLQualitair LLC Trustee · MichelstadtBuilt 1982 · S/N 6031 N110WYSm1019 LLC · Polson, MTBuilt 1976 · S/N 00-24 N111HFPlane Fun Inc Tr Trustee · Snellville, GABuilt 1968 · S/N 208 N112LPRanger Aviation Leasing LLC · Wilmington, DES/N 3403 N112SHBank Of Utah Trustee · Salt Lake City, UTBuilt 1966 · S/N 6567 N113RLMarks Aviation Group LLC · Lafayette, LABuilt 1981 · S/N 3306 N114GSAviation Company Inc · Cheyenne, WYBuilt 1976 · S/N 34 N114HDWindward Aviation Inc · Puunene, HIBuilt 1978 · S/N 280261D N1158BAir Gov 1 LLC · Rome, NYBuilt 1996 · S/N 4431 N115SUSignature Property Holdings LLC · Wilmington, DEBuilt 2021 · S/N 110868D N117HKSettan Corp · Goleta, CABuilt 1997 · S/N 4462 N118FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLBuilt 1991 · S/N 4182 N118TVInterstate Helicopter Inc · Bethany, OKBuilt 1979 · S/N 2844 N119TTaylor Robert T · Chehalis, WABuilt 1976 · S/N 760844S N11FHD H Helicopter Inc DBA · Sauget, ILBuilt 1993 · S/N 4270 N11ZXBig Bird Leasing Inc · Saint Peter, MNBuilt 1974 · S/N 640609S N1201WMagnum Aviation LLC · Goff, KSBuilt 1966 · S/N 7819 N1211MArchangelair LLC · Wilmington, DES/N 29002C N1219WMoes Crop Dusting Service Inc · Marysville, CABuilt 1975 · S/N 1843

Back to AD 72-03-06