Registered aircraft · 563

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-13-12-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-13-12-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-13-12-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-13-12-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-13-12-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-13-12-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.

N101ALRegistered aircraftBuilt 1980 · S/N U20605684 N102CQChatham County · Savannah, GABuilt 1999 · S/N 0901FF N104HHHaddock Flying Service Inc · Salters, SCBuilt 1960 · S/N 2062 N104RTBack Nine Aerial LLC · New Berlin, WIBuilt 1990 · S/N 51364 N105HHHaddock Flying Service Inc · Salters, SCS/N 1307 N108WWeyerhaeuser Nr Co · Eugene, ORBuilt 1993 · S/N 52034 N10JSSiegel Jerry S · Los Angeles, CAS/N 008 N10SPState Of Kentucky · Frankfort, KYBuilt 1983 · S/N 51064 N10TVHelicopters Inc · Cahokia, ILBuilt 1990 · S/N 51399 N111SPState Of Michigan · Lansing, MIBuilt 1990 · S/N 51325 N114SFN179sf LLC · Chandler, AZBuilt 1995 · S/N 52154 N118AEAir Evac Ems Inc · O Fallon, MOBuilt 1981 · S/N 45724 N119AEAir Evac Ems Inc · O Fallon, MOBuilt 1981 · S/N 51201 N1201WMagnum Aviation LLC · Goff, KSBuilt 1966 · S/N 7819 N121LPPremier Rotors LLC · Saint Martinville, LABuilt 1996 · S/N 52177 N123NMAglk LLC · Lewes, DES/N 6702 N124AEAir Evac Ems Inc · O Fallon, MOBuilt 1992 · S/N 51591 N12BFHutter Charles G · Carson City, NVBuilt 1974 · S/N 61P-0162-003 N12BQHelicopters Inc · Cahokia, ILBuilt 1993 · S/N 52012 N12JWRuffwood Inc · Atlanta, GABuilt 1997 · S/N 52193 N12SPNew York State Police · Albany, NYBuilt 2000 · S/N 49069 N132AEAir Evac Ems Inc · O Fallon, MOBuilt 1980 · S/N 45491 N1337KJsg Aviation LLC · Wilmington, DES/N 51110 N136TWSilver Creek Aviation Services · Fort Worth, TXBuilt 1986 · S/N 51188 N137MMAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2009 · S/N 52396 N13NNHelicopters Inc · Wilmington, DEBuilt 2008 · S/N 52380 N142CCMachinery Service Co Inc · Wiscasset, MEBuilt 1997 · S/N 5025 N142DPMarks Lloyd · Lafayette, LABuilt 1980 · S/N 45585 N146ETFour Creeks Aviation Inc · Visalia, CABuilt 1976 · S/N HA3046 N146SPSamaritan'S Purse · Boone, NCBuilt 2000 · S/N 52243 N14807Hammock Flying Service Inc · Smithville, ARBuilt 1972 · S/N 25078 N155TVU S Helicopters Inc · Marshville, NCBuilt 1990 · S/N 51339 N1576FCity Of Houston Police Dept · Houston, TXBuilt 2006 · S/N 0802FF N157BAAirmart Inc · Lexington, KYBuilt 1986 · S/N E-2339 N157PAPatriot Aviation Inc · Greenville, DEBuilt 2003 · S/N 52241 N157SJNorth Wind Aviation LLC · Cottage Grove, ORBuilt 1985 · S/N 51157 N1605KCounty Of Gwinnett Georgia · Lawrenceville, GABuilt 1988 · S/N 0604FF N1612Gm Leasing Co LLC · Broussard, LABuilt 1996 · S/N 53044 N161SFGm Leasing Co LLC · Broussard, LABuilt 2006 · S/N 52335 N163LHeli Fly Inc Trustee · Wilmington, DEBuilt 2019 · S/N 0317FF N164AETextron Financial Corp · Wichita, KSBuilt 2018 · S/N 52494 N165AETextron Financial Corp · Wichita, KSBuilt 2018 · S/N 52495 N166AETextron Financial Corp · Wichita, KSBuilt 2018 · S/N 52496 N169RLRotorcraft Leasing Co LLC · Broussard, LABuilt 1993 · S/N 52063 N170AMPremier Rotors LLC · Saint Martinville, LABuilt 1982 · S/N 51036 N17238Bennett Aviation LLC · Lafayette, LABuilt 1991 · S/N 51492 N173MSFlorida Keys Mosquito Control District · Marathon, FLBuilt 2000 · S/N 52256 N173RLRotorcraft Leasing Co LLC · Broussard, LABuilt 1993 · S/N 52066 N173SJAnthony Ghidossi Chemical LLC · Marysville, WABuilt 1981 · S/N 5170 N175HAShearer John · The Dalles, ORBuilt 1978 · S/N HA3075

Back to AD 81-13-12 R1