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.

N753MBSteel Diamond LLC · Sheridan, WYBuilt 1989 · S/N 560-0028 N75410United Airlines Inc · Chicago, ILBuilt 2001 · S/N 30127 N75425United Airlines Inc · Chicago, ILBuilt 2008 · S/N 33460 N75426United Airlines Inc · Chicago, ILBuilt 2008 · S/N 31622 N75428United Airlines Inc · Chicago, ILBuilt 2008 · S/N 31633 N75429United Airlines Inc · Chicago, ILBuilt 2008 · S/N 30130 N7542NHale Benjamin · Iowa City, IABuilt 1968 · S/N E-57 N75432United Airlines Inc · Chicago, ILBuilt 2009 · S/N 32835 N75433United Airlines Inc · Chicago, ILBuilt 2009 · S/N 33527 N75435United Airlines Inc · Chicago, ILBuilt 2009 · S/N 33529 N75436United Airlines Inc · Chicago, ILBuilt 2009 · S/N 33531 N7543NSteier Joseph E Trustee · Omaha, NES/N E-58 N7548NSorenson Mark E · Deaver, WYBuilt 1968 · S/N E-64 N7549NLauterbach Dennis R · Midlothian, TXBuilt 1968 · S/N E-66 N754CACarver Aero LLC · Davenport, IABuilt 2009 · S/N BB-2013 N754FXFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 208B0526 N754KPKalinin Partners LLC · Juneau, AKBuilt 2007 · S/N 208B1264 N754PMid Continent Harley Davidson Inc · Wichita, KSBuilt 1973 · S/N E-461 N754TWCentral Virginia Aviation Inc · North Dinwiddie, VAS/N LJ-754 N7550NReynolds Stephen C · Bayview, TXBuilt 1968 · S/N E-67 N755BCMav Management LLC · Rockledge, FLBuilt 1978 · S/N 421C0497 N755FXFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 208B0529 N755GHJeff Hux Farms LLC · Sikeston, MOBuilt 1997 · S/N TH-1838 N755KPKalinin Partners LLC · Juneau, AKBuilt 1999 · S/N 208B0759 N755RVWright Air Service Inc · Fairbanks, AKBuilt 2016 · S/N 208B5299 N756CAAc Spe 4 LLC · Orlando, FLBuilt 1991 · S/N 26547 N756FXFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 208B0532 N757AMKhorzad Kaveh · Austin, TXBuilt 1998 · S/N E-3181 N757ATAirtrex Aircraft Oscar Inc · Wichita, KSS/N FL-757 N757BAWw Air LLC · Burwell, NEBuilt 1984 · S/N LJ-1097 N757FVintage Aircraft LLC · Leesville, SCFirst renewal noticeS/N E-3121 N757GWGreenway Air LLC · Wilmington, DES/N BB757 N757PABmr Financial Inc · Kingston Springs, TNBuilt 1982 · S/N TH-1333 N757RHPanther Partnership Equipment I LLC · Gibsonton, FLS/N 421C1049 N757RK757 Romeo-Kilo Aviation LLC · Corpus Christi, TXFirst renewal noticeBuilt 1987 · S/N BB1278 N757TRRegistered aircraftS/N 560-0598 N7580BMec International Trading LLC · Daytona Beach, FLBuilt 1987 · S/N 208B0051 N7581FDesert Sand Aircraft Leasing Co Inc · Rosharon, TXBuilt 1994 · S/N 208B0389 N7586ZGould Aviation LLC · Aberdeen, SDBuilt 1985 · S/N FA71 N758ATAirtrex Aircraft Papa Inc · Wichita, KSS/N FL-758 N758CG Daniel Evans P C · Birmingham, ALBuilt 1981 · S/N TH-1275 N758CAAccess Denied Inc · Wilmington, DEBuilt 1978 · S/N TH-1001 N758PBas Part Sales LLC · Greeley, COBuilt 1999 · S/N TH-1907 N758WPAcr Aircraft LLC · Dover, DEBuilt 1975 · S/N TH-666 N759BABering Air Inc · Nome, AKBuilt 2021 · S/N 208B5630 N759MRMabarey LLC · Guaynabl, PRBuilt 2023 · S/N 208B5759 N759VLBarto Jerrel · Kula, HIS/N E-1164 N75ATGta Air Inc · Addison, TXBuilt 1974 · S/N E-597 N75CLClear LLC · Pierre, SDBuilt 1977 · S/N TH-878 N75DHBrent Staggs Medical Consulting LLC · Little Rock, ARBuilt 1993 · S/N 560-0215

Back to AD 2006-16-18 R1