Skip to content

Registered aircraft · 5,086

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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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.

N6916YDk1 Aviation LLC · Fayetteville, NCBuilt 1969 · S/N 27-4272 N691MAMitchell Martin · Alpine, CABuilt 2002 · S/N 3257291 N691SCSouthern Cross Aircraft LLC · Fort Lauderdale, FLS/N 1552 N692DWBroyles Danny Keith · New Castle, INBuilt 2005 · S/N 3257384 N6934JCopaair Maintenance Services Inc · Indiantown, FLBuilt 1976 · S/N 32R-7680389 N693MEDicky David J · Sierra Vista, AZS/N 3228 N693TCBrooks Janousek LLC · Kingsford, MIBuilt 1997 · S/N 20018 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

Back to AD 91-21-01 R1