AD 2002-13-07
Registered aircraft · 824
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-13-07')
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-13-07')
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-13-07') 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-13-07') 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.
N484ECConstellation Energy Generation LLC · New Castle, DEN488GBHanging Valley Aviation LLC · Green Bay, WIN488MHSmyrna Ready Mix Concrete LLC · Nashville, TNN48CGCorning Inc · Corning, NYN48FBWkc Corp · St Louis, MON48MFAm Specialty Insurance Co · Dallas, TXN48RRBase III Falcon LLC · Oklahoma City, OKN491NIndium Corporation Of America · Clinton, NYN493CFShamrock Air LLC · Baltimore, MDN499MHHollingshead Aviation Services LLC · Murfreesboro, TNN49HTPnc Bank Na · Boise, IDN4DFCds Equipment LLC · Cincinnati, OHN4FCFinco Aviation LLC · Sandy, UTN4HDRegistered aircraftN4SM4sm LLC · West Palm Beach, FLN4TTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN4WCMid-Atlantic Aviation IV LLC · St Petersburg, FLN500BLBnb LLC · Wilmington, DEN500FJGood Bus LLC · Midland, TXN500JJUltimate Human Aviation LLC · Coconut Grove, FLN500MAAndretti 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, UTN50LBRegistered aircraftN510HWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN510RHHms Holdings LLC · Charlotte, NCN512KSMcreynolds Aviation LLC · Dallas, TXN513DJCccnj F2000-169 LLC · Windermere, FLN513HSRanch Stadium Equipment Leasing Inc · Dallas, TXN513KDKd Aviation 51 LLC · Portland, ORN515ANResources Aviation Inc · Fort Lauderdale, FLN515CF5 Shues Leasing LLC · Waterford, MIFirst renewal noticeN515MFAh Jag LLC · Atlanta, GAN515PVPilot Travel Centers LLC · Knoxville, TNN516DGFalcon Air LLC · Los Angeles, CAN518SSFalconsn100 LLC · Roslyn, NYN5190Bsc Horizon LLC · Saint Louis, MON519JDDodson International Parts Inc · Rantoul, KSN520SCStryker Corp · Portage, MI
Back to AD 2002-13-07