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.

N67352Ascension Aviation LLC · Gaylord, MIBuilt 1979 · S/N TH-1098 N67353Registered aircraftBuilt 1983 · S/N E-2105 N6735PTarvin Darrel D · Huntsville, TXBuilt 1983 · S/N E-2104 N6735ZGta Air Inc · Addison, TXBuilt 1979 · S/N E-1605 N6736GKough Bryan · Scott City, KSBuilt 1980 · S/N E-1648 N6736NSalter Aviation LLC · Bowdon, GABuilt 1980 · S/N E-1695 N6736SA36 Aviation LLC · Boise, IDBuilt 1982 · S/N E-1987 N6736VSharkey Lowell G · Manitou, KYBuilt 1979 · S/N E-1569 N6737DMarlin Air LLC · Dallas, TXBuilt 1980 · S/N E-1651 N6739TJoca Holdings LLC · Kittrell, NCBuilt 1980 · S/N E-1652 N6739UKahler Automation Corp · Fairmont, MNBuilt 1979 · S/N E-1591 N673FEFederal Express Corp · Memphis, TNBuilt 1997 · S/N 780 N673HPBk Investment Co LLC · Jupiter, FLBuilt 1982 · S/N TH-1326 N67414Staley Clifford D · Delray Beach, FLBuilt 1980 · S/N E-1661 N6741DPerformance Aircraft C LLC · Litchfield Park, AZBuilt 1983 · S/N TH-1395 N6741WDempsey Justin · Hazlet, NJBuilt 1980 · S/N E-1660 N6742NCrazy Mountains Aviation LLC · Columbus, GAS/N TH-1140 N6742PPrice Paul · Lancaster, VABuilt 1980 · S/N E-1709 N6742SPowers Benjamin · Circleville, OHBuilt 1979 · S/N E-1635 N6745CTan Industries LLC · Wilmington, DEBuilt 1983 · S/N E-2109 N6745MPerkins Communication LLC · Northport, ALBuilt 1980 · S/N TH-1124 N6746TFlying Wolf LLC · Lomita, CABuilt 1980 · S/N E-1674 N6747JQualitair LLC Trustee · MichelstadtS/N E2130 N6747TYesco Administration LLC · Salt Lake City, UTBuilt 1984 · S/N TH-1403 N6747YZ2b Aviation LLC · San Antonio, TXS/N E-1676 N6748PSpears Derek · Los Angeles, CABuilt 1984 · S/N E-2131 N6749GLesh Air LLC · Denver, COBuilt 1980 · S/N E-1679 N6749LGtf Aviation LLC · Fryeburg, MEBuilt 1980 · S/N E-1678 N6749VUsg Assets Inc · Clarkesville, GABuilt 1980 · S/N E-1681 N674FEFederal Express Corp · Memphis, TNBuilt 1997 · S/N 781 N6750Z50 Zulu Aviation LLC · Williamston, MIBuilt 2012 · S/N 208B2340 N6754HAviation Communication And Surveillance Systems · Phoenix, AZBuilt 1980 · S/N LJ-891 N67551Takeoff Holdings LLC · Anchorage, AKBuilt 1983 · S/N E-2119 N6755QAeromed 36 LLC · Cedar Rapids, IABuilt 1984 · S/N E-2162 N6757DMcdonald Land & Cattle LLC · Muleshoe, TXBuilt 1980 · S/N E-1698 N6759CJds Aero LLC · Decatur, TXS/N E-1686 N6759GTrademark Services LLC · Vineyard Haven, MABuilt 1980 · S/N E-1682 N675BABerry Aviation Inc · San Marcos, TXBuilt 1980 · S/N 675 N675FEFederal Express Corporation · Memphis, TNBuilt 1998 · S/N 789 N675JZMercer Fraser Co · Brookings, ORBuilt 2015 · S/N 20800570 N675PCAir Transportation LLC · Madison, MSBuilt 2002 · S/N FL-352 N675RNLakeside Aviation LLC · Redwood City, CABuilt 1999 · S/N BB-1676 N675RSWeimer Bearing & Transmission Inc · Germantown, WIBuilt 2019 · S/N FL-1214 N675SMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N 20800675 N67607Bertrand William DBA · Milford, MIBuilt 1980 · S/N E-1750 N6763KAla Ark LLC · Germantown, TNBuilt 1984 · S/N LJ-1064 N6764KElemental Energy LLC · Portland, ORBuilt 1983 · S/N E-2102 N676BHTicknor Rodney J · Bridewater, IABuilt 1983 · S/N E-2121 N676CCInternational Air Services Inc Trustee · Carson City, NVBuilt 1984 · S/N 501-0676 N676FEFederal Express Corp · Memphis, TNBuilt 1998 · S/N 790

Back to AD 2006-16-18 R1