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.
N670UPWheels Up Partners LLC · New York, NYN673DCPhenom Aviation LLC · Monterey, CAN679KJN679kj LLC · Torrance, CAN680JHHodge Aviation LLC · Muskogee, OKN685ASEz Jet LLC · Plantation, FLN685UPWheels Up Partners LLC · New York, NYN6874SNaples Jet Center Holdings LLC · Naples, FLN688UPWheels Up Partners LLC · New York, NYN689MCLos Corales 601 Corp · South Padre Island, TXN68ERStarwood Air LLC · Missoula, MTN68NHAljobe Bajeky LLC · Levittown, NYN68TJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN690UPWheels Up Partners LLC · New York, NYN691UPWheels Up Partners LLC · New York, NYN692UPWheels Up Partners LLC · New York, NYN693UPWheels Up Partners LLC · New York, NYN696UPWheels Up Partners LLC · New York, NYN697ASExecutive Airshare LLC · Overland Park, KSN69FXPhenom489 LLC · New York, NYN69VKRegistered aircraftN6ARandolph Aviation LLC · Naples, FLFirst renewal noticeN6DKDeka Research & Development Corp · Manchester, NHN6DYN6dy LLC · Los Altos, CAN700AJIndigo Air LLC · Gulf Breeze, FLN701CMChronos Aviation LLC · El Paso, TXN701TWMeridian Asset Leasing LLC · Saint Louis, MON70CHCmh Homes Inc · Maryville, TNN710AXInnovative Aviation LLC · Naples, FLN710SCValiair Lc Trustee · Casper, WYN7117NTvpx Trust Co LLC Trustee · North Salt Lake, UTN711JTGuardian Air LLC · Hobart, WIN713GCGc Jets LLC · Big Sky, MTN713LVCarolina Air Transfer III LLC · Alpharetta, GAN713WDWinds Away 07 LLC · Houston, TXN715DEJt Air LLC · Nashville, TNN715JKJdv Solutions LLC · Coralville, IAN716LLLindemann Logistics LLC · Oshkosh, WIN717RSCcg Ventures LLC · Dallas, TXN720TWBravo Mike Corp · Burlington, MAN723GBBank Of Utah Trustee · Salt Lake City, UTN723NDHvmd Air LLC · Treasure Island, FLN725BSFlex Phenom LLC · Wapakoneta, OHN725TWBlenn Haven Logistics LLC · Parkersburg, WVN732ACRjc Leasing LLC · Appleton, WIN73DBPhenom Aviation LLC · Fayetteville, ARN750SCEnerquest Aviation Partners LLC · Midland, TXN752KKPremier Air Holdings LLC · Stuart, FLN755PJPem Acquisitions LLC · Phoenix, AZN75LHTkl Capital Holdings LLC · Newark, DEN75RZFlying Phenom LLC · Sheridan, WY
Back to AD 2021-24-21