AD 2018-04-13

Registered aircraft · 1,373

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-04-13')
    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-04-13')
  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.

N309JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N 20348N30PXRegistered aircraftBuilt 2025 · S/N 2312N30QAWood Asg LLC · Carrollton, TXBuilt 2012 · S/N 20357N30WDKing Aviation LLC · Dallas, TXBuilt 2021 · S/N 55010086N310JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 20591N310KEOneok Inc · Tulsa, OKBuilt 2024 · S/N 20987N310VZRan Air LLC · Driggs, IDBuilt 2012 · S/N 20366N311FCWheels Up Partners LLC · New York, NYBuilt 2010 · S/N 20298N311GSCh Aircraft LLC · Palm Beach, FLBuilt 2008 · S/N 20233N312EAAea Services LLC · Delray Beach, FLBuilt 2023 · S/N 20943N312HCUS Bank Na Trustee · Hartford, CTBuilt 2021 · S/N 20880N313CFEvans General Aviation LLC · Alpharetta, GABuilt 2022 · S/N 55010089N313DSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 20183N313VClyde Companies Inc · Orem, UTBuilt 2012 · S/N 20365N314JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 20100N314WCJrcg280 LLC · Houston, TXBuilt 2022 · S/N 2242N315JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 20030N316CSCaroler 316 LLC · Solon, OHBuilt 2007 · S/N 20180N316FXFlexjet LLC · Cleveland, OHBuilt 2025 · S/N 55010154N317FXStanley Steemer International Inc · Cleveland, OHBuilt 2024 · S/N 55010153N317JCFlying Horse Aviation LLC · Colorado Springs, COBuilt 2015 · S/N 2072N317VBVictor Bravo Air LLC · Dallas, TXS/N 20234N318CMCarter Aviation LLC · Salem, VABuilt 2016 · S/N 20661N318FXFlexjet LLC · Cleveland, OHBuilt 2024 · S/N 55010151N319FXFlexjet LLC · Cleveland, OHBuilt 2024 · S/N 55010150N31CAHf Sinclair Payroll Services Inc · Dallas, TXBuilt 2004 · S/N 20021N31MWNextera Energy Equipment Leasing LLC · West Palm Beach, FLBuilt 2017 · S/N 55000073N31TFN31tf LLC · Machesney Park, ILBuilt 2015 · S/N 20547N320FXBraxton Aviation II LLC · Cleveland, OHBuilt 2024 · S/N 55010149N320JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 20155N320KETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 20594N320LXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 20417N321FXConnie 749 LLC · Cleveland, OHBuilt 2024 · S/N 55010148N322FXYnwa LLC · Cleveland, OHBuilt 2024 · S/N 55010147N323FXRegistered aircraftBuilt 2024 · S/N 55010146N324FXBoardwalk Auto Group LLC · Cleveland, OHBuilt 2024 · S/N 55010145N325FXFlexjet LLC · Cleveland, OHBuilt 2024 · S/N 55010137N325PEPeco Air LLC · Park City, UTBuilt 2015 · S/N 20409N325TGFlying G Aviation LLC · Atlanta, GABuilt 2014 · S/N 20455N325WJDorado Aircraft Leasing LLC · Jupiter, FLBuilt 2014 · S/N 20449N326FXTriple F Management LLC · Cleveland, OHBuilt 2024 · S/N 55010143N327FXCp Wings II LLC · Cleveland, OHBuilt 2024 · S/N 55010139N328FXFrank J Blair · Cleveland, OHBuilt 2024 · S/N 55010128N328RSHolloman Ventures Aviation LLC · Houston, TXBuilt 2012 · S/N 20382N329FXFlexjet LLC · Cleveland, OHBuilt 2023 · S/N 55010124N32JF32jhf LLC · Phoenix, AZBuilt 2022 · S/N 2251N32TSCsc Delaware Trust Company Trustee · Wilmington, DEBuilt 2025 · S/N 55010162N32TXPresidio Air Ventures LLC · Houston, TXBuilt 2025 · S/N 55020221N330FXRegistered aircraftBuilt 2025 · S/N 55010157N330PJKhcl LLC · Cincinnati, OHBuilt 2006 · S/N 20102
Back to AD 2018-04-13