Registered aircraft · 11,797

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.

N143ELPremiere Aviation Inc · Concord, CABuilt 1979 · S/N 421C0646 N143FWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N LJ-1612 N143SATwin Otter International Ltd · Las Vegas, NVBuilt 1978 · S/N 591 N143TAJrr Motor Sales LLC · Campbellsville, KYBuilt 1984 · S/N BB-1183 N143UPUnited Parcel Service Co · Louisville, KYBuilt 2002 · S/N 0826 N143WAWright Air Service Inc · Fairbanks, AKBuilt 2012 · S/N 208B5002 N143ZUsda Forest Service Fire & Aviation · Boise, IDBuilt 1974 · S/N 437 N144CMeyers Construction Inc · Fresno, CABuilt 1991 · S/N FL-49 N144CAKingdom Heir Aviation LLC · Frisco, TXBuilt 1992 · S/N 650-7004 N144KPrescott Medical Relief Services LLC · Prescott, AZBuilt 1977 · S/N E-947 N144KMKcc Av LLC · Fayetteville, ARBuilt 2001 · S/N 560-0579 N144PTHill Howard H Trustee · Portage, WIBuilt 1990 · S/N E-2553 N144TDDahlberg Thomas K · Belvidere, ILBuilt 1999 · S/N E-3289 N144UPUnited Parcel Service Co · Louisville, KYBuilt 2002 · S/N 0827 N1450BBerry Boger Yacht Sales Inc · North Myrtle Beach, SCBuilt 1977 · S/N E-989 N1459General Atomics Aeronautical Systems Inc · San Diego, CABuilt 2009 · S/N FL-667 N145AFDale Aviation Inc · Rapid City, SDS/N LJ-1721 N145GPTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 20800722 N145KAKamaka Air LLC · Honolulu, HIBuilt 2008 · S/N 208B2019 N145KKDodson International Parts Inc · Rantoul, KSBuilt 1994 · S/N 560-0276 N145TSBonanza A36 LLC · Wildwood, MOBuilt 1999 · S/N E-3235 N145UPUnited Parcel Service Co · Louisville, KYBuilt 2002 · S/N 0828 N145WAMartinaire Aviation LLC · Addison, TXBuilt 2005 · S/N 208B1145 N146LCSaratoga Homes Of Texas San Antonio LLC · El Paso, TXBuilt 1982 · S/N BB1046 N146MMJackdaw Inc Trustee · Wilmington, DEBuilt 1997 · S/N 5250226 N146TJBirdboys2 Aviation LLC · Boerne, TXBuilt 1978 · S/N 421C0500 N146UPUnited Parcel Service Co · Louisville, KYBuilt 2003 · S/N 829 N146WMWatermakers Air Inc · Fort Lauderdale, FLBuilt 2000 · S/N 208B-0813 N14704United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28765 N14731United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28799 N14735United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28950 N147DTGabriella Elena Inc · Winnetka, ILBuilt 1998 · S/N E-3163 N147GXAltair Aviation LLC · Missoula, MTBuilt 1987 · S/N 214 N147LJGuardian Flight LLC · Lewisville, TXS/N LJ-1476 N147NCorr Aviation Inc · Oxford, MSBuilt 2021 · S/N 208B5626 N147PWBarr Tammy D · Spicewood, TXBuilt 2001 · S/N E-3420 N147UPUnited Parcel Service Co · Louisville, KYBuilt 2003 · S/N 830 N1482BClear Line Aviation LLC · St George, UTBuilt 2015 · S/N 525-0888 N148DSEast Ramp Aviation LLC · Baton Rouge, LABuilt 1986 · S/N TH-1439 N148SAZuni LLC · Kirkland, WAS/N 409 N148SKBering Air Inc · Nome, AKBuilt 1995 · S/N UE-148 N148UPUnited Parcel Service Co · Louisville, KYBuilt 2003 · S/N 0831 N149AFTitan Group Inc · Tucson, AZS/N 421C-0098 N149CCCianbro Corp · Baltimore, MDS/N FA-145 N149GJAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2016 · S/N 208B5283 N149UPUnited Parcel Service Co · Louisville, KYBuilt 2003 · S/N 832 N149WLCarter Robert J Jr · Oak Ridge, TNS/N E3562 N149XAEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1993 · S/N 27149 N14AJChalk 2 Inc · Apple Valley, CABuilt 1980 · S/N TH-1154 N14CEFacility Concepts Developments LLC · Jackson, MSBuilt 1989 · S/N TH-1562

Back to AD 2006-16-18 R1