Registered aircraft · 5,075

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:84-19-03-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:84-19-03-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:84-19-03-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:84-19-03-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:84-19-03-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:84-19-03-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.

N6940FRebel Ranch LLC · Glenwood, ARBuilt 1976 · S/N 32R-7780050 N6943YAce Tomato Co LLC · Daytona Beach, FLBuilt 1969 · S/N 27-4350 N6944APacific Fleet Aviation LLC · Rochester, NYBuilt 1979 · S/N 27-7954109 N6944YLg Aztec LLC · Boynton Beach, FLBuilt 1969 · S/N 27-4304 N694BKBell Bruce · Desert Aire, WABuilt 1969 · S/N 1851582 N694BWOtter Creek Aviation LLC · Columbus, GABuilt 2004 · S/N T18208262 N694DBHammond Flying Club Inc · Covington, LABuilt 1975 · S/N 32-7540087 N694PCBajedi Aviation LLC · Lewes, DEBuilt 2002 · S/N 3257305 N694RJAtlas 182rj LLC · Port Townsend, WABuilt 2005 · S/N T18208473 N6952YPorterfield Brian B · Wasilla, AKBuilt 1969 · S/N 27-4316 N6953JDubois Marcus S · Olive Branch, MSBuilt 1976 · S/N 32R-7680393 N6954JHughston Thomas Price · NorfolkBuilt 1976 · S/N 32R-7680394 N6955YN6955y LLC · Knoxville, IABuilt 1969 · S/N 27-4320 N6956YTolsma Michael J · Hawthorne, NJBuilt 1969 · S/N 27-4321 N6961JBaja Airventures Inc · Chula Vista, CABuilt 1976 · S/N 32R-7680395 N6962SYeaman John Robert IV · Aroda, VABuilt 2000 · S/N 4636272 N696JANational Industrial Services LLC · Kingshill, VIBuilt 1965 · S/N 27-2924 N6970YBell Daniel E · Alexandria, KYBuilt 1969 · S/N 27-4337 N6971YNovember Nine One Four Eight Juliet LLC · Fulton, MOBuilt 1969 · S/N 27-4338 N697WHAgri Enterprises LLC · Hopkinsville, KYBuilt 1983 · S/N 31-8352008 N698HNelson Bobby E · Naples, FLBuilt 1968 · S/N 27-4106 N698VWSheppard Louis A · Queens Village, NYBuilt 1974 · S/N 31-7405408 N699MDJvation LLC · Belgrade, MTBuilt 1994 · S/N 4622159 N699TBUS Anesthesia Consultants LLC · Chesterfield, MOBuilt 1994 · S/N 4622158 N69CPBuena Vista Hunting LLC · Eagle Pass, TXBuilt 2005 · S/N T20608564 N69FMAirtime LLC · South Lyon, MIBuilt 1976 · S/N 32R-7680200 N69JWWarrior Aviation LLC · Dollar Bay, MIBuilt 1972 · S/N 31036 N69LHGraham Jack · Hamilton, TXBuilt 1977 · S/N 32R-7780323 N69LVTbd Air LLC · Chatham, MABuilt 2001 · S/N 3257229 N69MKFisher Jack C · Ashland City, TNBuilt 1998 · S/N 3257063 N69PTAerofix Structural Service LLC · Horn Lake, MSS/N 1397-143 N69WPHutcheson Jon · Greencastle, INBuilt 1973 · S/N 32-7440015 N6ARBluewater Airmotive Corporation · Wilmington, DEBuilt 1973 · S/N 31-7300914 N6HTColorado By Air LLC · Salida, COBuilt 2003 · S/N T20608387 N6UCZborowski Ronald W · Eighty-Four, PABuilt 1975 · S/N 27-7554079 N7008FSouthbound Aviation LLC · Jackson, TNBuilt 1976 · S/N 32-7740012 N700ABSale Reported · Lewes, DESale reported, pending cancellationBuilt 1977 · S/N 61P-0401-139 N700AKCampbell Mark D · Ashford, ALBuilt 1979 · S/N 70017 N700CMoss Donald · Pinecrest, FLBuilt 1974 · S/N 31-7405497 N700GCRicks Auto Clinic Inc · Raytown, MOBuilt 1977 · S/N 32-7740054 N700GLPitcock Aviation LLC · Tompkinsville, KYBuilt 1967 · S/N 31-83 N700HWHotel Whiskey LLC · Sylvania, OHBuilt 1999 · S/N T20608034 N700KFTurbine Motor Conversions LLC · Orange, CABuilt 1984 · S/N H-10 N700LDNorthridge Consulting Enterprises LLC · Santa Clarita, CABuilt 1981 · S/N 62P-928-8165051 N700MFEtavan LLC · Satellite Beach, FLBuilt 1976 · S/N 61P-0282-064 N700VWCondor Aviation LLC · Bethlehem, PABuilt 1984 · S/N 60-8423012 N700WZPinto Robert · Sicklerville, NJBuilt 1984 · S/N 60-8423007 N700YWHorwath Ricky N · Saint James City, FLBuilt 1979 · S/N 70029 N7010FEconomou Michael · Falls Church, VAS/N 32R-7780051 N7016FNations One For Christ · Duluth, MNS/N 32R-7780052

Back to AD 84-19-03 R1