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.
N610EPTug Hill Aviation LLC · Fort Worth, TXN611ECB&R Leasing LLC · Inver Grove Hgts, MNN613RJenkins Aviation Inc · North Charleston, SCN617AEmbraer Executive Aircraft Inc · Melbourne, FLN620ASHgh Aviation LLC · Wilmington, DEN623DTRg Aviation LLC · Sinking Spring, PAN627DBBailey Aviation Holdings LLC · Hayden, IDN628ALParker Acres LLC · Kalispell, MTN628DSDisam Air LLC · Daytona Beach, FLN629JJBenton Aviation LLC · Millersburg, OHN62SQGold Star Aviation Inc · Salisbury, NCN63007Woody In The Sky With Diamonds LLC · New York, NYN631ADWheels Up Partners LLC · New York, NYN631JSDrrt Mobility Services Inc · Fort Lauderdale, FLN636DKCraig May LLC · Chico, CAN636SDOld Bonita Air LLC · Marshall, TXN637AS637as Aviation LLC · Las Vegas, NVN640DPDodson International Parts Inc · Rantoul, KSN640HCC & S Aviation LLC · Newport, ARN6422ZFgc Corrmed Aero Inc · Benton, KYN644RMWeldon Air LLC · Chaffee, MON645BBunn Family Corp · Springfield, ILN647ASCavern Aviation LLC · Lenexa, KSN648DXQuest Diagnostics Clinical Laboratories Inc · Reading, PAN648MEMid-West Hose & Specialty Inc · Oklahoma City, OKN649DXAsa Parts LLC · Dallas, TXN650UPWoodland Drive Crossing LLC · Riverside, CTN651UPWheels Up Partners LLC · New York, NYN652UPInfinity & Beyond LLC · Fort Lauderdale, FLN653UPUmb Bank Na Trustee · Salt Lake City, UTN654UPWheels Up Partners LLC · New York, NYN654WBSunridge Properties Inc · Mesa, AZN655UPUmb Bank Na Trustee · Salt Lake City, UTN656UPWheels Up Partners LLC · New York, NYN657UPUmb Bank Na Trustee · Salt Lake City, UTN658UPUmb Bank Na Trustee · Salt Lake City, UTN659UPUmb Bank Na Trustee · Salt Lake City, UTN65KZKinze Aircraft LLC · Williamsburg, IAN661UPInfinity & Beyond LLC · Fort Lauderdale, FLN662JMJtl Investments LLC · Phoenix, AZN662UPWheels Up Partners LLC · New York, NYN664UPUmb Bank Na Trustee · Salt Lake City, UTN665ABBank Of Utah Trustee · Salt Lake City, UTN665ASJssi Parts LLC · Chicago, ILN665UPInfinity & Beyond LLC · Fort Lauderdale, FLN667UPWheels Up Partners LLC · New York, NYN668UPUmb Bank Na Trustee · Salt Lake City, UTN669AGFlying Time Machine LLC · Dover, DEN66JSan Sophia Aviation LLC · Carrollton, GAN66MCj Leasing Services LLC · San Diego, CA
Back to AD 2021-24-21