Registered aircraft · 433

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

N16002Commonweath Of Massachusetts · East Boston, MAS/N 0194E N1602LSaxton Helicopter Leasing LLC · Plymouth, MIS/N 0225E N1604ZDept Of Fish Wildlife And Parks · Helena, MTBuilt 1989 · S/N 0341E N16050Venturi Aviation LLC · Missoula, MTS/N 0276E N16062Flight Inspection LLC · Springdale, WABuilt 1989 · S/N 0349E N16069Paragon Air Group · Fort Worth, TXBuilt 1990 · S/N 0433E N1610BBlackstead Investments Inc · Boise, IDBuilt 1991 · S/N 0480E N161LAAir2 LLC · Blountville, TNBuilt 1981 · S/N 711015D N165HMidvale Air Research LLC · Lewes, DEBuilt 1985 · S/N 0150E N166MBHelicopter Roundup Service LLC · Nephi, UTBuilt 1980 · S/N 1000831D N167ALFerguson And Sons Construction LLC · Emmett, IDBuilt 1977 · S/N 270083D N16EYCarleton Inc Trustee · Wilmington, DEBuilt 1992 · S/N 0501E N173ALFulton Timothy E · Salem, MOBuilt 1976 · S/N 1160020D N175JLRatcliff Dustin · Saltville, VABuilt 1977 · S/N 270076D N18CPPeoples Properties LLC · Tucson, AZBuilt 1990 · S/N 383E N18GHCity And County Of Honolulu · Honolulu, HIS/N LN014 N193VSVertol Systems Co Inc · Destin, FLBuilt 1981 · S/N 110882D N195VSVertol Systems Co Inc · Destin, FLBuilt 1981 · S/N 110826D N209ECYavapai County · Prescott, AZBuilt 2007 · S/N RN074 N20FLLocker Fred · Muleshoe, TXBuilt 2008 · S/N 0592E N212ELMark Mondo Building & Excavating Inc · Reno, OHBuilt 1982 · S/N 1097D N212VTLaroche Aviation Services LLC · Bellaire, OHBuilt 1981 · S/N 811039D N215MBunn Mary E · Williamstown, WVBuilt 1997 · S/N LN083 N220PDCity Of Oakland · Oakland, CABuilt 1993 · S/N 0509E N221TGCollier Mosquito Control District · Naples, FLBuilt 1981 · S/N 410951D N225HRHeliwild Investments LLC · Austin, TXS/N 890559D N228KKKeagy Ken · Central Point, ORBuilt 1987 · S/N 0248E N229HLAviation Advantage Inc · Tabor City, NCBuilt 1995 · S/N 0519E N230MDAir2 LLC · Blountville, TNBuilt 1981 · S/N 510978D N234RFMhoc LLC · Pensacola, FLBuilt 1987 · S/N 0255E N240FLAir2 LLC · Blountville, TNBuilt 1978 · S/N 480298D N241JHChatham County Mosquito Control · Savannah, GAS/N 0233E N261VSVertol Systems Company Inc · Destin, FLFirst renewal noticeS/N RN061 N262WAWindward Aviation Inc · Puunene, HIBuilt 1979 · S/N 790554D N266VSVertol Systems Company Inc · Destin, FLBuilt 2002 · S/N RN066 N28MLTre Aviation Corp · Wilmington, DEBuilt 1978 · S/N 1080362D N297ECounty Of Kern · Bakersfield, CAS/N 197E N298PPGillespie Flying Services LLC · Trenton, SCBuilt 1982 · S/N 0006E N299DRKings County Sheriffs Office · Hanford, CABuilt 1986 · S/N 196E N300FXFxc Nation Leasing LLC · Palm Springs, FLBuilt 2000 · S/N RN056 N301HFCity And County Of Honolulu · Honolulu, HIS/N LN075 N302HFCity And County Of Honolulu · Honolulu, HIBuilt 1992 · S/N LN023 N303HFHonolulu Fire Department · Honolulu, HIBuilt 1994 · S/N LN064 N305JEDah Aircraft LLC · Georgetown, SCBuilt 1982 · S/N 1194D N311VTGeco Inc · Wilmington, DEBuilt 1987 · S/N 0229E N315SHJc Aircraft Leasing LLC · Wasilla, AKS/N 1120D N316HKHawkeye Holdings LLC · Lyndon, KSBuilt 1979 · S/N 390479D N31HMDah Aircraft LLC · Georgetown, SCBuilt 1977 · S/N 1160027D N321PERadnor Construction Of Delaware Inc · Allentown, PABuilt 1989 · S/N 0342E N331WHSchreindl Lawrence A · Colton, ORS/N 0207E

Back to AD 2000-08-22