OpenAirDocs.org
AD 2021-06-06

Registered aircraft · 194

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

N1088YRegistered aircraftBuilt 2018 · S/N 65139N108LGSaje Aviation Inc · Calabasas, CABuilt 2021 · S/N 65357N1116SCity Of Stockton · Stockton, CAS/N 65176N121AEAea Aviation LLC · Purchase, NYBuilt 2024 · S/N 65605N121TATurf Air LLC · East Northport, NYBuilt 2019 · S/N 65239N1243YTurbines Ltd · West Point, NEBuilt 2018 · S/N 65137N12YAHelicopters Inc · Wilmington, DEBuilt 2018 · S/N 65103N13RMIndigo Aviation Inc · Savannah, GABuilt 2021 · S/N 65372N14JBPbs Holdings LLC · Missoula, MTBuilt 2024 · S/N 65594N153LLLee Aviation Services LLC · Wilson, NCBuilt 2019 · S/N 65227N181RN181r LLC · Fort Lauderdale, FLBuilt 2021 · S/N 65359N192RBWestern Pilot Service Inc · Phoenix, AZBuilt 2017 · S/N 65022N196TVGriffin Television Tulsa LLC · Oklahoma City, OKBuilt 2024 · S/N 65512N210GHRegistered aircraftN-number assigned, not yet registeredS/N 65765N2112SRocinante Air LLC · Wilmington, DES/N 65023N225BAR&R Testing Inc · Watertown, SDBuilt 2025 · S/N 65690N23451Bell Textron Inc · Fort Worth, TXS/N 65780N23454Bell Textron Inc · Fort Worth, TXS/N 65781N23455Bell Textron Inc · Fort Worth, TXS/N 65783N240PDCity Of Omaha · Omaha, NEBuilt 2019 · S/N 65177N24CZWestern Sky Aviation LLC · Scottsdale, AZBuilt 2018 · S/N 65142N25KHHorizons Unlimited Air Inc · Hillsboro, ORS/N 65436N279PDCity Of Sacramento · Sacramento, CABuilt 2018 · S/N 65102N286MABank Of Utah Trustee · Salt Lake City, UTS/N 65072N296RBell Textron Inc · Fort Worth, TXBuilt 2022 · S/N 65379N29ARN29ar LLC · Macon, GABuilt 2019 · S/N 65214N300GDJem Spin LLC · Bedford, NHBuilt 2022 · S/N 65427N306FDCity Of Los Angeles · Van Nuys, CABuilt 2023 · S/N 65520N307BWBw Leasing LLC · Athens, GAS/N 65271N307FDCity Of Los Angeles · Van Nuys, CABuilt 2022 · S/N 65421N30BHHover Partners LLC · Fort Worth, TXBuilt 2018 · S/N 65090N313FLCae USA Inc · Tampa, FLBuilt 2023 · S/N 65466N314VDOtd Aviation LLC · Bethesda, MDBuilt 2018 · S/N 65101N318GVWings & Rotor LLC · Wilmington, DEBuilt 2019 · S/N 65221N32APGlaze Adams Enterprises LLC · North Little Rock, ARBuilt 2019 · S/N 65268N337APAir Panthere LLC · Phoenix, AZBuilt 2024 · S/N 65588N337HGHappy Heli Holdings LLC · Flint, MIBuilt 2021 · S/N 65337N340PDCity Of Omaha · Omaha, NEBuilt 2023 · S/N 65497N347CSLeon County Florida · Tallahassee, FLBuilt 2020 · S/N 65272N356BPIntermountain Air Inc · Colorado Springs, COBuilt 2022 · S/N 65451N35CBBlackhawk 787 LLC · Columbus, OHBuilt 2022 · S/N 65444N361CTTwo Blades LLC · Port Orange, FLBuilt 2024 · S/N 65603N373NENebraska State Patrol · Lincoln, NEBuilt 2021 · S/N 65364N394MB78cl Aviation LLC · Ogden, UTBuilt 2018 · S/N 65127N404CJRyan Investments LLC · Yuma, AZBuilt 2023 · S/N 65468N42JBAlliance Aircraft Sales Inc · Pierre, SDBuilt 2018 · S/N 65091N442LNMead Zane · Lubbock, TXBuilt 2019 · S/N 65265N451LCBlue Wings Aviation LLC · Summerfield, NCBuilt 2023 · S/N 65495N459PTGlc Ventures Capital Holdings LLC · Ponder, TXBuilt 2020 · S/N 65292N45VGJunfer Flyers LLC · Wilmington, DEBuilt 2024 · S/N 65590
Back to AD 2021-06-06