AD 2002-01-09
Registered aircraft · 439
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:2002-01-09')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-01-09')
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:2002-01-09') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-01-09') 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.
N888NTNbt Air LLC · Baton Rouge, LAN888WGJ & M Aircraft LLC · Applegate, ORN88GBPratt Group Leasing LLC · Niles, MIN88QDQuest Diagnostics Clinical Laboratories Inc · Reading, PAN894DMLone Rock Aviation LLC · Santa Rosa, CAN895VAN179sf LLC · Chandler, AZN898AJNext Gen Air LLC · Colorado Springs, CON8YUFat City Air Service LLC · Aspen, CON900HSBizair LLC · Wilmington, DEN901AKA C Sunni LLC · Santa Monica, CAN902AKDillon Aero Inc · Phoenix, AZN903PJHelibro LLC · Red Bluff, CAN903SMSterling Air Service LLC · Corpus Christi, TXN906STBthc LLC · Chattanooga, TNN909WRDumont Associates Inc · Morris Plains, NJN911UCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN911VMGuardian Flight LLC · Lewisville, TXN911VUAir Methods LLC · Greenwood Village, CON911WNGuardian Flight LLC · Lewisville, TXN913NMSan Juan Regional Medical Center Inc · Farmington, NMN917WWPeregrine Group LLC · Dallas, TXN91BDuck Bill LLC · Athens, GAN925HWNorthstar Flying LLC · Fort Lauderdale, FLN928SBBoutique Air Inc · Dallas, TXN92AGKatmai Air LLC · Anchorage, AKN944BTGlobal Aircraft Services LLC · Exeter, CAN946JJBetten Equipment Leasing Inc · Grand Haven, MIN950KMMimg Transportation LLC · Franktown, CON954KMKilo Mike Aviation LLC · Fort Lauderdale, FLN956PCAeroshare 2 LLC · Salt Lake City, UTN957STCorporate Fleet Services LLC · Cornelius, NCN95CRCwr Holdings LLC · Wilmington, DEN970NARegistration Pending · Greenwood Village, CORegistration pendingN977XLStevens Air LLC · Fort Myers, FLN9792Green Mallard Aviation LLC · Wilmington, DEN98VKFb Aviation Services LLC · Wilmington, DEN98WSSilverbird LLC · Reno, NVN991GFGuardian Flight LLC · Lewisville, TXN999EETropacaval Media LLC · Victoria, TX
Back to AD 2002-01-09