AD 2002-14-19
Registered aircraft · 2,057
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-14-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-14-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-14-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-14-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.
N153SLSouthwest Aviation Specialties LLC · Tulsa, OKN1544VGuardian Flight LLC · Lewisville, TXN154AKAviation Resources Group Inc · Fort Lauderdale, FLN154GLAlpine Aviation Inc · Provo, UTN154KFRegistered aircraftN1552DDodson International Parts Inc · Rantoul, KSN1552GEast Atlantic Aviation LLC · Edenton, NCN1553GMccloy Mark · Tatum, NMN155AVTeton Leasing LLC · Pocatello, IDN155BBRegistration Pending · Greer, SCRegistration pendingN155CAHeavylift Cargo Airlines Inc · Kingman, AZN155CJUe-55 LLC · Helena, MTN155SYRocky Mountain Aviation LLC · Aberdeen, IDN156DHFs Sean Lee LLC · Rochester, NYN156LAFresno Beverage Co Inc DBA · Fresno, CAN156TMWilmington Trust Co Trustee · Wilmington, DEN157CKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN15GABering Air Inc · Nome, AKN15SYGoldman Richard D · Litchfield Park, AZN15WCDakota Aviation LLC · Santa Ana, CAN160BPBeeson John S · Houston, TXN160BSSierra Bravo LLC · Galveston, TXN160CRBas Part Sales LLC · Greeley, CON160EEPlane Part Solutions LLC · West Palm Beach, FLN160EMTjh Falcon2 LLC · San Antonio, TXN160GGThin Air Holding LLC · Dover, DEN160RWRitch Air LLC · Visalia, CAN160SJEcho Acquisitions LLC · Dover, DEN160SLCash Depot Ltd · Green Bay, WIN160SMAviation Star S LLC · Beaumont, TXN162GCUnited States Department Of Interior · Boise, IDN162QMartin Foundry Service Inc · Glencoe, ALN163LFRdt Air LLC · Hattiesburg, MSN164WSBank Of Utah Trustee · Salt Lake City, UTN1655MMichigan Aeronautics Commission · Lansing, MIN165TGAmj Aviation LLC · Oneida, TNN165YVAlpine Aviation Inc · Provo, UTN166CLKa Partners LLC · Thomson, GAN167UDodson International Parts Inc · Rantoul, KSN1685SBella Vista Transportation & Rentals LLC · Dunnellon, FLN168HLSelectjet Lease LLC · Grand Rapids, MNN168ZZBwc Holdings Ltd · Greenwood Village, CON169DRLegacy Aviation LLC · Tea, SDN169GLAlpine Aviation Inc · Provo, UTN169LJSelect Jet Lease II LLC · Grand Rapids, MNN169RWJorgensen Air Service LLC · Puyallup, WAN16CMBartholow Rental Co Inc · Wylie, TXN16CSDodson International Parts Inc · Rantoul, KSN16HGBear Air LLC · Mount Vernon, INN16KWWild Blue Aviation LLC · Wilmington, DE
Back to AD 2002-14-19