AD 2021-24-21
Registered aircraft · 898
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-24-21')
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-24-21')
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:2021-24-21') 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-24-21') 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.
N833LCTcb Capital Holdings LLC · Winter Park, FLN835TBTraylor Air LLC · Evansville, INN839NNicholas Services LLC · Oxford, MSN83RXRegistered aircraftN843SG843sg Holdings LLC · Hilton Head Island, SCN851LGLala Guidry Investments LLC · Madisonville, LAN853GRMig Real Estate LLC · Newport Beach, CAN855EEAllen D Swell LLC · Houston, TXN858EERbl Aviation LLC · Aspen, CON85SGWhite Sands Equipment Leasing LLC · Inlet Beach, FLN860CTSpairco LLC · Nacogdoches, TXN862LGMaxair LLC · Appleton, WIN86CUFisco Air LLC · Bayamon, PRN86KMUmb Bank Na Owner Trustee · Salt Lake City, UTN86TGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN871RVKt Construction LLC · Russellville, KYN876JCFlyakite Inc · Beverly Hills, CANon-citizen corporation, flight hours not reportedN87HGWinter Haven Aero Group Inc · Bradenton, FLN87PWSoaring Winds LLC · Glenns Ferry, IDN881RECead LLC · Fort Lauderdale, FLN886DBAircraft Holding And Leasing LLC · Sarasota, FLN886WOwlbear LLC · Oakland, CAN88EJOscar Mike Ventures LLC · Dover, DEN88FWFw Tailwind LLC · Fort Worth, TXN88LVWya Air LLC · Sullivans Island, SCN88WEmbraer Executive Aircraft Inc · Melbourne, FLN894JHJack Henry & Associates Inc · Monett, MON895JHJack Henry And Associates Inc · Monett, MON896BLLeon Phenom LLC · Miami, FLN896JHWard Aviation LLC · Longmont, CON897JHN D Air LLC · Kansas City, MON898MWN898mw Inc Trustee · Wilmington, DEN899DXQuest Diagnostics Clinical Laboratories Inc · Reading, PAN89JJAtlantis Aviation LLC · Frisco, TXN8BDEmpower Air II LLC · Richardson, TXN8KDBt Consulting LLC · Wilsonville, ORN8PCTubing Rentals LLC · Robstown, TXN8PGPerihelion Aviation LLC · Sarasota, FLN900HTFarsight Technologies Inc · Big Bear Lake, CAN904DHBank Of Utah Trustee · Salt Lake City, UTN906KBAerospace Holding & Leasing LLC · Sarasota, FLN909EMEmbraer Executive Aircraft Inc · Melbourne, FLN90PQ15 Holdings LLC · Zionsville, INN910XS910jk LLC · Wilmington, DEN911EJOakley In The Clouds LLC · Lake Wales, FLN911YA700pc LLC · Santa Barbara, CAN914EGMs Aviation LLC · Los Angeles, CAN914MLRapid Aviation LLC · Ocoee, FLN915WKRoofkan 2016 LLC · Naples, FLN918STKenmore Crew Leasing Inc Trustee · Bellingham, WA
Back to AD 2021-24-21