Registered aircraft · 11,798

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:2006-16-18-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:2006-16-18-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:2006-16-18-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:2006-16-18-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:2006-16-18-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:2006-16-18-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.

N50CMWizard Aviation LLC · Redding, CABuilt 2004 · S/N 560-0661 N50EBDavis Aviation Inc · Brandon, MSBuilt 1975 · S/N LW-128 N50ELSesa Aviation LLC · Weslaco, TXBuilt 1989 · S/N 5600036 N50FGRegenerative Sports Tissue Bank Inc · Lawrenceville, GABuilt 1988 · S/N 187 N50GGN50gg Leasing LLC · Ponca City, OKBuilt 2000 · S/N BB-1728 N50JDMillennium Aviation New York LLC · Rochester, NYBuilt 2018 · S/N FL-1149 N50KGTurbo Air Charter LLC · Boise, IDBuilt 1982 · S/N BB-1066 N50KLLiberty Leasing V LLC · Melbourne, FLBuilt 2004 · S/N 258671 N50LWildcat Aeroplanes LLC · Sedalia, COBuilt 1977 · S/N 421C0431 N50LQCu V LLC · Stuart, FLBuilt 1996 · S/N 560-0347 N50MReese Dave A · Capistrano Beach, CABuilt 1993 · S/N 525-0031 N50MWWj Of Delaware Inc · Fort Lauderdale, FLS/N 503 N50NABv Transportation LLC · Portland, ORBuilt 1995 · S/N BB1504 N50NBLexington Air Services LLC · Lexington, MSBuilt 1984 · S/N S550-0022 N50PACenterline Aviation Inc · Middletown, DEBuilt 1988 · S/N BB-1308 N50PCSpritle LLC · Chicago, ILBuilt 2000 · S/N 308 N50PDParker Long LLC · Lexington, NCS/N LJ-1704 N50SNFirst Quality Falcon LLC · Great Neck, NYBuilt 2000 · S/N 310 N50SSAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2000 · S/N TH-1961 N50TW17 Aviation LLC · Oklahoma City, OKBuilt 1999 · S/N 650-7097 N50USN50us LLC · New Orleans, LABuilt 1991 · S/N 560-0145 N50VPDale Aviation Inc · Rapid City, SDBuilt 1988 · S/N LJ-1185 N50XDynamic Avlease Inc · Bridgewater, VABuilt 1985 · S/N BB-1239 N50YPVillages Equipment Co · Leesburg, FLBuilt 2005 · S/N 344 N50YTInternational Aviation Technical Services Inc · Torrance, CABuilt 1996 · S/N 269 N50ZPPalen Mark T Trustee · Cleveland, TNBuilt 1975 · S/N 421C0022 N51Textron Aviation Inc · Wichita, KSS/N FL-1378 N510FCFerguson And Sons Construction LLC · Emmett, IDBuilt 1980 · S/N 5010098 N510FROneflight International Inc · Englewood, COBuilt 1984 · S/N 446 N510GSAmdel Holding LLC · Houston, TXBuilt 2001 · S/N BB-1746 N510JNCu IV LLC · Stuart, FLBuilt 1995 · S/N 560-0295 N510MPPark Avenue Aircraft Trust LLC Trustee · Dover, DEBuilt 1984 · S/N 140 N510SDChg Jets LLC · Orange, CABuilt 1988 · S/N 650-0161 N510SMGolden Leaf Tobacco Company Inc · Keysville, VAS/N 421C0112 N510TCSkyview Aviation LLC · Hartwell, GAS/N E-1469 N5111PDe La Vega Artemio · Dallas, TXBuilt 1986 · S/N LJ-1136 N511CMartin Gary N · Lake Jackson, TXBuilt 2004 · S/N E-3576 N511CFFendler Michael J · Pittsfield, MEBuilt 1977 · S/N TH-833 N511DGarmin International Inc · Olathe, KSBuilt 1997 · S/N FL-172 N511DFKma Aviation LLC · Phoenix, AZBuilt 1980 · S/N TH-1175 N511DHLandlocked Company LLC · Dover, DES/N 511 N511ECMississippi Air Express LLC · Madison, MSBuilt 1993 · S/N 525-0013 N511EXCannery Leasing Ltd · Friday Harbor, WABuilt 2013 · S/N 208B5011 N511GAGeaux Aire LLC · Savannah, GABuilt 1993 · S/N BB1462 N511JCIntermodal Air LLC · Frankfort, ILBuilt 2001 · S/N 258518 N511KVDelta Fox LLC · Woodland, CABuilt 1995 · S/N LJ1422 N511RAKeenan Michael John Trustee · Anchorage, AKS/N E-2746 N511SPFassas Alexander D · Richmond, KYBuilt 1976 · S/N E-910 N511TAAir Med Services LLC · Lafayette, LABuilt 1999 · S/N BB-1660 N511TCBam Aviation Of New York LLC · Sanford, FLBuilt 1994 · S/N 525-0074

Back to AD 2006-16-18 R1