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.
N681ZLZulu Lima LLC · Marshfield, MAN684KFJcg Aviation LLC · Park Ridge, ILN685KFJcg Aviation LLC · Park Ridge, ILN688CPAircraft Guaranty Corp Trustee · Oklahoma City, OKN68HCHca Squared LLC · Nashville, TNN690SPRegistered aircraftN695PPilot 1958 LLC · Knoxville, TNN69FHCarol 1 LLC · Nashville, TNN700DSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN702AKMatapalo Holdings LLC · Hialeah, FLN702NWNext Wave Aviation LLC · Henderson, NVN703PPOvation Jet Parts LLC · Dover, DEN704JDClear Horizon Investments LLC · Overland Park, KSN705WLAspen Peak LLC · Houston, TXN707BEMoonraker Aviation LLC · Blacksburg, VAN707MTMt 7 Aircraft LLC · Dallas, TXN709DPWilmington Trust Co Trustee · Wilmington, DEN70LXLimerick Aviation LLC · Denver, CON70TFRex Realty Co · Saint Louis, MON710ETQuack Quack LLC · Portland, ORN713AGAgee Richard E · Houston, TXN714JBOjw LLC · Wilmington, DEN715CBPilot 1958 LLC · Knoxville, TNN717TFRegistered aircraftN71949Wilshire Rental Corp · Dallas, TXN719MCCdm Leasing LLC · Shelby Township, MIN720WYIron Bar Enterprises LLC · Hampstead, NCN722FSBank Of Utah Trustee · Salt Lake City, UTN722JBClos De Berry Leasing Ltd · New Carlisle, OHN729FSRegistration Pending · Oklahoma City, OKRegistration pendingN72TVTvpx Trust Co LLC Trustee · North Salt Lake, UTN733AHumana Inc · Louisville, KYN733HHumana Inc · Louisville, KYN733KHumana Inc · Louisville, KYN73FJTla73 LLC · Santa Rosa Beach, FLN745CXCdmorg Inc · Little Rock, ARN748REHawk Air LLC · Waukegan, ILN748RMInterbank · Dover, DEN74XPN74xp LLC · Tualatin, ORN750JEJae Aviation LLC · Englewood, CON759QWorking Group LLC · Sarasota, FLN75EKInto Air Aviation LLC · Clearwater, FLN75ENCsc Delaware Trust Co Trustee · Wilmington, DEN7600GSas Institute Inc · Cary, NCN767LDCaribbean Ops LLC · Dover, DEN769JWRegistered aircraftN76BBank Of Utah Trustee · Salt Lake City, UTN771BVBbs I LLC · Vancouver, WAN771HMHmhc Inc · Plymouth Meeting, PAN774GHNext Generation Pdx LLC · Oregon City, OR
Back to AD 2002-23-19