Skip to content

AD 2006-16-18 R1

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.

N75GMMandes George J · Homer, AKBuilt 2010 · S/N 20800518 N75LTLaughing Giraffe Aviation LLC · Millsboro, DEBuilt 1998 · S/N 525-0241 N75LVCook Childrens Health Enterprises · Fort Worth, TXS/N BB-1075 N75LW4t Aviation LLC · Maypearl, TXBuilt 1973 · S/N LW-75 N75MSDodson International Parts Inc · Rantoul, KSBuilt 1983 · S/N LA204 N75PGDasch Air LLC · Alamo, CABuilt 1995 · S/N LJ-1390 N75RSCentral Virginia Aviation Inc · North Dinwiddie, VAS/N LJ-533 N75TMMilazzo Holdings LLC · Wales, WIBuilt 1995 · S/N 560-0296 N75VKMaranatha Leasing & Consulting Inc · Marco Island, FLBuilt 2019 · S/N 525-1042 N75WPSalt River Project Agric Improvement & Power Dist · Phoenix, AZBuilt 1997 · S/N 560-0449 N75WSWs Energy Services LLC · Corpus Christi, TXBuilt 2017 · S/N FL-1106 N76Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-11 N7601NIndustrial Maintenance Inc · Pryor, OKS/N E-68 N7603NBucher John R · Rch Palos Vr, CABuilt 1968 · S/N E-71 N7604NFriedman David B · Martinez, CABuilt 1968 · S/N E-72 N7607BTechnical Education Services Inc · Virginia Beach, VABuilt 1947 · S/N D-854 N7607NBonn Aire LLC · Henderson, NVBuilt 1968 · S/N E-76 N760ADAtwood Distributing Lp · Enid, OKBuilt 2021 · S/N FL-1248 N760ASNorsan Investors LLC · Concord, CABuilt 2007 · S/N 560-0760 N761FEFederal Express Corporation · Memphis, TNBuilt 1991 · S/N 208B0254 N761JBSchwechten Physician Services Pllc · New Waverly, TXBuilt 1969 · S/N E-163 N761RVWright Air Service Inc · Fairbanks, AKBuilt 2016 · S/N 208B5334 N76254United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30779 N76265United Airlines Inc · Chicago, ILBuilt 2001 · S/N 31585 N76269United Airlines Inc · Chicago, ILBuilt 2001 · S/N 31588 N76288United Airlines Inc · Chicago, ILBuilt 2004 · S/N 33451 N762CACullum Transportation LLC · North Charleston, SCBuilt 1981 · S/N 421C1214 N762FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0255 N762MG1mg LLC · Fort Wayne, INBuilt 1982 · S/N 035 N762MWMichael Wayne Investment Co · Virginia Beach, VABuilt 2018 · S/N FL-1141 N762PPAway Air LLC · Wilmington, DES/N BB-1897 N762RVWright Air Service Inc · Fairbanks, AKBuilt 2016 · S/N 208B5340 N762TBAero Crafter LLC · Miami, FLBuilt 1977 · S/N 421C0213 N7639NLarson Gregory W · Waxahachie, TXBuilt 1968 · S/N E-60 N763FEFederal Express Corporation · Memphis, TNBuilt 1991 · S/N 208B0256 N763JCPilot Services Of Ohio LLC · Loveland, OHBuilt 1976 · S/N 421C0211 N763PPTop Air Texas LLC · Glendale, CABuilt 1999 · S/N 278 N7645NFour Five November LLC · Helena, MTBuilt 1968 · S/N E-65 N7646NBown George M · Shady Shores, TXBuilt 1968 · S/N E-69 N76498Doucey Mark R · The Villages, FLS/N E2607 N764CACarver Aero LLC · Muscatine, IABuilt 1991 · S/N BB-1408 N764JSAhw Aviation Inc · Anchorage, AKBuilt 2007 · S/N 560-0776 N764TSullivan Jerald S · Gilbert, AZBuilt 1973 · S/N E-392 N76502United Airlines Inc · Chicago, ILBuilt 2006 · S/N 31603 N76503United Airlines Inc · Chicago, ILBuilt 2006 · S/N 33461 N76504United Airlines Inc · Chicago, ILBuilt 2006 · S/N 31604 N76505United Airlines Inc · Chicago, ILBuilt 2006 · S/N 32834 N76508United Airlines Inc · Chicago, ILBuilt 2008 · S/N 31639 N7650NHamilton Marcus · Grosse Pointe Park, MIBuilt 1968 · S/N E-77 N76514United Airlines Inc · Chicago, ILBuilt 2008 · S/N 31626

Back to AD 2006-16-18 R1