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.

N1826LRhr Management Inc · Bancroft, WIBuilt 1976 · S/N E-845 N1826VBig Blue Sky Aero LLC · Austin, TXBuilt 1997 · S/N E-3086 N18271Ramsey Richard K · Houston, TXBuilt 1977 · S/N E-1068 N18275Strong Tower Worship Center LLC · Delhi, LAS/N E-1071 N1827LCone James R Jr · Lubbock, TXS/N TH-741 N18284Condor Aviation LLC · Bethlehem, PABuilt 1977 · S/N E-1073 N18290Koelbel Scott W · Spring, TXBuilt 1977 · S/N E-1076 N18296Star Flight Aviation Inc · Shreveport, LABuilt 1977 · S/N TH-844 N1829ECorporate Airtime LLC · Clinton, MSBuilt 1981 · S/N TH-1282 N1829WRight Wing LLC · Newnan, GABuilt 1973 · S/N E-387 N182CASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1981 · S/N LA-121 N182UAUnited Airlines Inc · Chicago, ILBuilt 1991 · S/N 25279 N18302Allison Aircraft Sales LLC · Avon, CTBuilt 1977 · S/N E-1081 N18308Jlmc Blackland LLC · Marietta, GABuilt 1977 · S/N E-1083 N1830FKing Barry J · Bentonville, ARBuilt 1981 · S/N E-1905 N1830MDcf30 Corp · Doral, FLS/N E575 N1830SN1830s Aviation LLC · Gainesville, GABuilt 1981 · S/N E-1906 N1830VStress Aircraft Holdings LLC · Pilot Mountain, NCBuilt 1997 · S/N E-3087 N1831DBeliveau E Charles · West Newbury, MABuilt 1981 · S/N E-1907 N18320Cox Jack H Jr · Arlington, TXBuilt 1977 · S/N TH-849 N18326Vanmeter Paul · Sunnyvale, TXBuilt 1977 · S/N E-1094 N18327Franco Nello · Burlingame, CABuilt 1978 · S/N E-1286 N1832BR&S Acquisitions LLC · Weatherford, TXBuilt 1981 · S/N E-1908 N1834SMillan Person Aircraft Inc · Austin, TXS/N E-1909 N18351Iowa Great Lakes Flyers Ltd · Cheyenne, WYBuilt 1977 · S/N TH-855 N18356N18356 LLC · Hayden, IDBuilt 1977 · S/N E-1101 N18358Life Is A Beech LLC · Los Lunas, NMFirst renewal noticeBuilt 1977 · S/N TH-814 N1835FMt Explore LLC · Kalispell, MTBuilt 1984 · S/N E-2157 N18361Landvater Darryl V · Williston, VTBuilt 1981 · S/N TH-1290 N18364Goeken Peter C · Dakota Dunes, SDBuilt 1977 · S/N TH-854 N18367Benoit Farms LLC · Centralia, MOBuilt 1977 · S/N E-1103 N1836BSalt River Dreamers LLC · Santa Rosa Beach, FLBuilt 1985 · S/N E-2270 N1836FDe210 LLC · Sandy Springs, GABuilt 1983 · S/N E-2111 N1836LFlexjet LLC · Cleveland, OHBuilt 1977 · S/N E-1111 N18378Lodi Airport Maintenance Corp · Las Vegas, NVS/N E-1106 N18386Gamco Aviation LLC · Shreveport, LABuilt 1977 · S/N TH-856 N1838RSix Zero Zulu LLC · Kalispell, MTBuilt 1981 · S/N E-1916 N18394Bas Part Sales LLC · Greeley, COBuilt 1977 · S/N E-1121 N183CTUltimate Resort Vacations Inc · Weston, FLBuilt 2010 · S/N 208B2183 N183DMDodson International Parts Inc · Rantoul, KSS/N 258335 N183EHarkins Harrison J Trustee · Hayden, IDBuilt 1982 · S/N E-2034 N183PSkytech Cc LLC · Santa Rosa Beach, FLBuilt 2000 · S/N E-3346 N183PASandy Wings LLC · Wilmington, DEBuilt 1984 · S/N 385 N183SADriscoll David A · Savannah, TNBuilt 1973 · S/N LJ571 N183VBRegistration Pending · Palm City, FLRegistration pendingBuilt 1977 · S/N E-1097 N18402Ohlhauser Devin · Bismarck, NDBuilt 1977 · S/N E-1117 N18403Bas Part Sales LLC · Greeley, COBuilt 1977 · S/N E-1120 N18404Cactus Aviation Llp · Gotha, FLBuilt 1977 · S/N E-1122 N18431Stall Benjamin A · Piedmont, OKBuilt 1977 · S/N E-1129 N18456Hewson Robert A · Santa Barbara, CABuilt 1977 · S/N E-1131

Back to AD 2006-16-18 R1