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.

N931PCJac Tay LLC · Saint Louis, MOBuilt 2002 · S/N E-3446 N931SMAccomplished Air LLC · Camden, DES/N FL-1132 N931SRIsr Aviation LLC · Wilmington, DES/N 525-0175 N931TTrustmark Bank · Jackson, MSBuilt 2016 · S/N FL-1041 N931TNJude Aviation LLC · Clarksville, TNBuilt 2023 · S/N 525-1150 N9326QLoyd Tracy · Broken Arrow, OKBuilt 1971 · S/N TH-186 N932ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29530 N932CRedding Aero Enterprises Inc · Redding, CABuilt 1987 · S/N 208B0032 N932NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33488 N932SPSouthern Airways Pacific LLC · Addison, TXBuilt 2014 · S/N 208B5177 N9331BMartinaire Aviation LLC · Addison, TXBuilt 1987 · S/N 208B0055 N933ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30080 N933CAMetrea Special Aerospace Isr Inc · Bethany, OKBuilt 2002 · S/N FL-372 N933NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 31173 N933PBApp Concepts LLC · Wichita, KSBuilt 2002 · S/N 560-0618 N933RGMsblt LLC · Hobe Sound, FLBuilt 2016 · S/N 525-0933 N933RTZito Aviation LLC · La Salle, COS/N BB-955 N933SBShea Brothers Air LLC · Irondale, ALBuilt 2008 · S/N FL586 N934ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29531 N934CWM2 Aviation LLC · Rockledge, FLBuilt 2016 · S/N 525-0934 N934FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0034 N934NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33489 N934PCBennell Ltd LLC · Naples, FLBuilt 2002 · S/N E-3448 N935AJDouble C Air LLC · Sacramento, CABuilt 1981 · S/N BB-935 N935AMAirmed International LLC · Birmingham, ALBuilt 1994 · S/N LJ-1356 N935ANAmerican Airlines Inc · Ft. Worth, TXBuilt 2000 · S/N 30081 N935BDDiamond Aviation LLC · Dublin, GABuilt 1996 · S/N FL-155 N935FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0035 N935HPrestige Jets Inc · Dover, DENon-citizen corporation, flight hours not reportedBuilt 1992 · S/N NA0475 N935JWGross Todd D · Minden, NVBuilt 1982 · S/N E-1945 N935NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 33231 N936AFVasquez Ahyde E · Brownsville, TXS/N 421C0606 N936ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29532 N936BRMgt Interests LLC · Navasota, TXBuilt 1985 · S/N S550-0058 N936CAAc Spe 8 LLC · Orlando, FLBuilt 1991 · S/N 25308 N936FEFederal Express Corp · Memphis, TNBuilt 1987 · S/N 208B0036 N936HRPymp LLC · Nashville, TNBuilt 2005 · S/N 258743 N936NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 31176 N936PHataway Clayton Scott · Leesburg, VABuilt 1985 · S/N E-2244 N936SIrving Holdings LLC · Greensboro, NCBuilt 1999 · S/N E-3258 N936SAHalpin Cuyler · Lewisville, TXBuilt 1999 · S/N E-3277 N936VN936v LLC · Knoxville, TNBuilt 1975 · S/N E-686 N936WDCorporate Velocity Inc · Pawleys Island, SCBuilt 1997 · S/N E-3130 N9379QSale Reported · Pottsboro, TXSale reportedBuilt 1972 · S/N E-305 N937ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30082 N937CKSchuman Carriage Company Ltd · Honolulu, HIBuilt 2005 · S/N 208B1118 N937NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 31178 N9385QOxer James E · Lake Placid, FLBuilt 1970 · S/N TH-49 N938ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 29533 N938BDB And M Aircraft Inc · Wilmington, DES/N E-3436

Back to AD 2006-16-18 R1