OpenAirDocs.org
AD 2018-07-13

Registered aircraft · 967

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-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-07-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.

N612RGT&A Aviation LLC · Wilmington, DEBuilt 2024 · S/N 680A0400N615QSRegistered aircraftBuilt 2021 · S/N 680A0267N616ECCj Leasing LLC Trustee · Lakeland, FLBuilt 2026 · S/N 680A0467N616QSRegistered aircraftBuilt 2020 · S/N 680A0246N618KFTextron Aviation Inc · Wichita, KSS/N 680A0492N6197DElysian Claims Svcs LLC · Newbury Park, CABuilt 2008 · S/N 510-0088N61HHCorsair Two LLC · Hillsboro, ORBuilt 2011 · S/N 510-0393N61JDMillennium Aviation New York LLC · Rochester, NYBuilt 2015 · S/N 680A0019N620QSRegistered aircraftBuilt 2018 · S/N 680A0162N620WBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 510-0162N621QSRegistered aircraftBuilt 2018 · S/N 680A0163N622QSRegistered aircraftBuilt 2021 · S/N 680A0268N623QSRegistered aircraftS/N 680A0247N624GFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2022 · S/N 680A0295N624QSRegistered aircraftBuilt 2019 · S/N 680A0232N624SVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 680-0124N625QSRegistered aircraftBuilt 2020 · S/N 680A0240N626LATextron Aviation Inc · Wichita, KSBuilt 2016 · S/N 680A-0026N626QSRegistered aircraftBuilt 2018 · S/N 680A0164N627QSRegistered aircraftBuilt 2020 · S/N 680A0241N628QSRegistered aircraftBuilt 2019 · S/N 680A0178N629QSRegistered aircraftBuilt 2021 · S/N 680A0269N62PEImpulse Circulation Services Inc · Redlands, CABuilt 2011 · S/N 510-0363N62SPRegistered aircraftBuilt 2010 · S/N 510-0357N62WMPayette Aviation Leasing LLC · Kirkland, WABuilt 2012 · S/N 510-0396N630DBChallenge Tool & Manufacturing Inc · New Haven, INBuilt 2008 · S/N 510-0130N630QSRegistered aircraftBuilt 2019 · S/N 680A0179N631CBKmac Aircraft Company LLC · Lafayette, LAS/N 680-0227N631QSRegistered aircraftBuilt 2019 · S/N 680A0180N632QSRegistered aircraftBuilt 2019 · S/N 680A0181N633QSRegistered aircraftBuilt 2021 · S/N 680A0271N635QSRegistered aircraftBuilt 2021 · S/N 680A0282N636QSRegistered aircraftBuilt 2019 · S/N 680A0182N637QSRegistered aircraftBuilt 2019 · S/N 680A0184N637SVTextron Financial Corp · Wichita, KSBuilt 2005 · S/N 680-0037N638AHTfk Aviation Inc · Malibu, CABuilt 2009 · S/N 510-0167N638QSRegistered aircraftBuilt 2022 · S/N 680A0330N639QSRegistered aircraftBuilt 2019 · S/N 680A0193N63BZTextron Aviation Inc · Wichita, KSS/N 680A0493N63LHTextron Aviation Inc · Wichita, KSS/N 680A0499N63TMLivre Air LLC · Cincinnati, OHBuilt 2005 · S/N 680-0019N640QSRegistered aircraftBuilt 2020 · S/N 680A0242N641QSRegistered aircraftBuilt 2020 · S/N 680A0259N645QSRegistered aircraftBuilt 2019 · S/N 680A0194N6464Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 680-0158N646QSRegistered aircraftBuilt 2021 · S/N 680A0261N648JWGosmartair LLC · Harrisburg, PABuilt 2008 · S/N 510-0073N649QSRegistered aircraftBuilt 2019 · S/N 680A0195N650QSRegistered aircraftBuilt 2019 · S/N 680A0196N651QSRegistered aircraftBuilt 2021 · S/N 680A0273
Back to AD 2018-07-13