AD 2002-23-19
Registered aircraft · 486
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-23-19')
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-23-19')
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-23-19') 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-23-19') 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.
N46HADjt Equipment LLC · Cocoa Beach, FLN470MKBank Of Utah Trustee · Salt Lake City, UTN472KChoice Hotels International Services Corp · Rockville, MDN47VWG 137 LLC · Wilmington, DEN480ECRegistered aircraftN482ECConstellation Energy Generation LLC · New Castle, DEN483CMAircraft Trustee Services Inc Trustee · Dover, DEN483ECRegistered aircraftN4840WGolden Ben Air LLC · Nashville, TNN484ECConstellation Energy Generation LLC · New Castle, DEN488GBHanging Valley Aviation LLC · Green Bay, WIN48FBWkc Corp · St Louis, MON48MFAm Specialty Insurance Co · Dallas, TXN48RRBase III Falcon LLC · Oklahoma City, OKN491NIndium Corporation Of America · Clinton, NYN49HTPnc Bank Na · Boise, IDN4FCFinco Aviation LLC · Sandy, UTN4HDRegistered aircraftN4WCMid-Atlantic Aviation IV LLC · St Petersburg, FLN500FJGood Bus LLC · Midland, TXN500MAAndretti Autosport Aviation LLC · Fort Lauderdale, FLN500RHHms Holdings LLC · Charlotte, NCN500WAWestern Aviation LLC · Fort Worth, TXN501KLKl Air LLC · Mooresville, NCN501MMN501mm LLC · North Little Rock, ARN501NSoinair LLC · Beavercreek, OHN501RRSpeedway Motorsports LLC · Charlotte, NCN502BGCapital Holdings 209 LLC · Newark, DEN503DJDodson International Parts Inc · Rantoul, KSN504WTHerin Aviation LLC · Spring, TXN506DJJrw Falcon LLC · Staten Island, NYN506MWOgbjet III LLC · Overland Park, KSN507DJFirm Foundation Aviation LLC · Brea, CAN508DJBank Of Utah Owner Trustee · Salt Lake City, UTN513DJCccnj F2000-169 LLC · Windermere, FLN513KDKd Aviation 51 LLC · Portland, ORN515ANResources Aviation Inc · Fort Lauderdale, FLN515CF5 Shues Leasing LLC · Waterford, MIFirst renewal noticeN515PVPilot Travel Centers LLC · Knoxville, TNN516DGFalcon Air LLC · Los Angeles, CAN518SSFalconsn100 LLC · Roslyn, NYN519JDDodson International Parts Inc · Rantoul, KSN520SCStryker Corp · Portage, MIN526DJMs Falcon LLC · East Spring Valley, NYN527DAJory Aviation LLC · Edina, MNN529KGCapstone Management LLC · Manchester, NHN531JDRonin Tori Leasing LLC · Bloomfield Hills, MIN5379FN5379f LLC · Canton, OHN53LTVpc Aviation LLC · Valencia, CAN53NJLear 100kz LLC · Burnet, TX
Back to AD 2002-23-19