Registered aircraft · 1,083

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:83-03-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:83-03-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:83-03-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:83-03-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:83-03-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:83-03-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.

N13FBFirebird Holdings LLC · Fort Worth, TXS/N 118 N13KJCarlston Carl Vaughn · Murray, UTBuilt 1991 · S/N 0444E N13TZAerospace Trust Management LLC Trustee · Wilmington, DES/N S550 N142CCMachinery Service Co Inc · Wiscasset, MEBuilt 1997 · S/N 5025 N144BHAbc Helicopters Inc · Jefferson, WIBuilt 1975 · S/N 1600 N145ALQuicksilver Air Inc · Fairbanks, AKBuilt 1980 · S/N 1200856D N146ETFour Creeks Aviation Inc · Visalia, CABuilt 1976 · S/N HA3046 N146SHScott'S Helicopter Services · Le Sueur, MNBuilt 1973 · S/N 957 N147AGTop Gun Precision Ag LLC · Skidmore, TXBuilt 1980 · S/N 3145 N14807Hammock Flying Service Inc · Smithville, ARBuilt 1972 · S/N 25078 N14837Oscar Aerial Spraying LLC · Grady, OKBuilt 1972 · S/N 850 N150AGInternational Air Services Inc Trustee · Carson City, NVBuilt 1971 · S/N 1090201M N150F11 11 Enterprises LLC · San German, PRBuilt 1975 · S/N 1866 N151ECEcolift Corp · San Juan, PRBuilt 1969 · S/N MB-1 N152CAChem Air LLC · Shreveport, LABuilt 1978 · S/N 2342 N154EHRedbull North America Inc · Camarillo, CABuilt 1985 · S/N S-704 N156CAChem-Air LLC · Shreveport, LABuilt 1976 · S/N 1999 N157BAAirmart Inc · Lexington, KYBuilt 1986 · S/N E-2339 N15THHeliservice LLC · Wilmington, DEBuilt 2003 · S/N 0564E 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 N160JAAg-Air Inc · Brent Alger, CAS/N 391 N1610BBlackstead Investments Inc · Boise, IDBuilt 1991 · S/N 0480E N1612Gm Leasing Co LLC · Broussard, LABuilt 1996 · S/N 53044 N161LAAir2 LLC · Blountville, TNBuilt 1981 · S/N 711015D N162SHCastro Be LLC · Wilmington, DES/N 7607 N164KMemphis Police Department · Memphis, TNBuilt 1988 · S/N 4000 N164RLRotorcraft Leasing Company LLC · Broussard, LABuilt 1997 · S/N 53140 N165HMidvale Air Research LLC · Lewes, DEBuilt 1985 · S/N 0150E N165JKBohica Consulting Services Of Nevada Inc · Boulder City, NVBuilt 1980 · S/N 2930 N166MBHelicopter Roundup Service LLC · Nephi, UTBuilt 1980 · S/N 1000831D N16715Cahaba Forestry Services LLC · Flowood, MSBuilt 1976 · S/N 2110 N167ALFerguson And Sons Construction LLC · Emmett, IDBuilt 1977 · S/N 270083D N16810Southern Helicopter Services Inc · Millington, TNBuilt 1977 · S/N 2231 N16979Withrotor Aviation Inc · Lakeview, ORS/N 2346 N169AAPierce Associates LLC · Prineville, ORBuilt 1973 · S/N 990 N16EYCarleton Inc Trustee · Wilmington, DEBuilt 1992 · S/N 0501E N16JDTriple F Flying Inc · Benton, PABuilt 1971 · S/N 71-20435 N16QRegistration Pending · Fredericksburg, VARegistration pendingS/N 1290227S N170SSOlathe Spray Service Inc · Olathe, COBuilt 1963 · S/N 2827 N171WHWestwind Helicopters Inc · Santa Fe, TXBuilt 1997 · S/N 53149 N173ALFulton Timothy E · Salem, MOBuilt 1976 · S/N 1160020D N173SJAnthony Ghidossi Chemical LLC · Marysville, WABuilt 1981 · S/N 5170 N1751Gm Leasing Co LLC · Broussard, LABuilt 1981 · S/N 3284 N175HAShearer John · The Dalles, ORBuilt 1978 · S/N HA3075 N175JLRatcliff Dustin · Saltville, VABuilt 1977 · S/N 270076D

Back to AD 83-03-02 R1