AD 2018-07-01

Registered aircraft · 346

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
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:2018-07-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2018-07-01')
  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.

N159AHVanderbilt University Medical Center · Nashville, TNBuilt 2023 · S/N 2224N159MTMed-Trans Corp · Denton, TXBuilt 2015 · S/N 1199N1601HValkyrie Europe LLC · Seattle, WABuilt 2013 · S/N 1134N162AECharlotte-Mecklenburg Hospital Authority · Charlotte, NCBuilt 2013 · S/N 1125N162MWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 0162N163BFAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 0671N165WCWca Holdings V LLC · Missoula, MTS/N 0454N166MTMed-Trans Corp · Denton, TXS/N 1167N1FLRegistered aircraftBuilt 2022 · S/N 2168N1VRegistered aircraftBuilt 2023 · S/N 2247N200HNAir Methods LLC · Greenwood Village, COS/N 0444N200UPKmv Leasing LLC · Shreveport, LABuilt 1999 · S/N 0089N2066FTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 2066N217FArrow Aviation Company LLC · Broussard, LABuilt 2005 · S/N 0438N217TArrow Aviation Company LLC · Broussard, LABuilt 2005 · S/N 0441N222HNHealthnet Aeromedical Services Inc · Charleston, WVBuilt 2025 · S/N 2289N223WLMed-Trans Corp · Denton, TXBuilt 2024 · S/N 2286N224VVMed-Trans Corporation · Denton, TXBuilt 2025 · S/N 2299N225LXMed Trans Corp · Denton, TXBuilt 2025 · S/N 2313N226SABennett Aviation LLC · Elmhurst, ILBuilt 2007 · S/N 0559N228BJBristow LLC · Lake Charles, LABuilt 2011 · S/N 0982N228MTAir Evac Ems Inc · O Fallon, MOBuilt 2010 · S/N 0908N230AMAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 0540N235AMAir Methods LLC · Greenwood Village, COS/N 0140N235DHMetro Aviation Inc · Shreveport, LABuilt 1999 · S/N 0058N235LLMercy Hospital Springfield · Springfield, MOBuilt 2008 · S/N 0662N240HYAspirus Wausau Hospital Inc DBA · Wausau, WIBuilt 2022 · S/N 2170N244AMAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 0610N252SABennett Aviation LLC · Elmhurst, ILBuilt 2008 · S/N 0707N253AMAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 0663N253MTMed-Trans Corp · Denton, TXBuilt 2014 · S/N 1153N253SABennett Aviation LLC · Elmhurst, ILBuilt 2010 · S/N 0890N261AMAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 0734N273AMAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 0273N300HNAir Methods LLC · Greenwood Village, COBuilt 2024 · S/N 2292N301MFQuad City Helicopter Emergency Medical Service · Davenport, IABuilt 2019 · S/N 2109N301PHPhi Health LLC · Tempe, AZBuilt 2004 · S/N 0355N302NMBristow LLC · Lake Charles, LABuilt 2011 · S/N 0987N302PHPhi Health LLC · Tempe, AZBuilt 2004 · S/N 0364N303PHPhi Health LLC · Tempe, AZBuilt 2004 · S/N 0372N304PHPhi Health LLC · Tempe, AZBuilt 2005 · S/N 0386N305MFQuad City Helicopter Emergency Medical Service · Davenport, IABuilt 2020 · S/N 2120N305PHPhi Health LLC · Tempe, AZBuilt 2005 · S/N 0395N308PHPhi Health LLC · Tempe, AZBuilt 2005 · S/N 0401N309PHPhi Health LLC · Tempe, AZBuilt 2005 · S/N 0403N30RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2011 · S/N 1001N311MFQuad City Helicopter Emergency Medical Service · Davenport, IABuilt 2012 · S/N 1069N311PHPhi Health LLC · Tempe, AZBuilt 2005 · S/N 413N312PHPhi Health LLC · Tempe, AZBuilt 2005 · S/N 0404N312RXReach Air Medical Services LLC · Mcclellan, CABuilt 2013 · S/N 1099
Back to AD 2018-07-01