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.
N365TX235jb LLC · Lewes, DEN368MBAffiliated Investments LLC · Auburn Hills, MIN36EPJsm At Falcon II LLC · Piscataway, NJN370MHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN372EXReal Estate Services International LLC · Conshohocken, PAN373EFEmpirical Foods Inc · Dakota Dunes, SDN374RVLmrv Falcon LLC · Phoenix, AZN375GKKs Air 3-7-12 V LLC · Charlotte, NCN376SFSmithfield Packaged Meats Corp · Smithfield, VAN377AGCrest Operations LLC · Pineville, LAN37DFWillamette Flight Management LLC · Mcminnville, ORN37EATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN37MDTriangle Aviation LLC · Dover, DEN38015Registered aircraftN380FJAviation Resource Group Inc · Fort Lauderdale, FLN388FJKey Corp · Cleveland, OHN38CPRegistered aircraftN404WCCheckmark II LLC · Burnet, TXN405DDillon Aviation LLC · Detroit, MIN406NLL&N Transit LLC · Salem, ORN408LSJokyal LLC · White Plains, NYN40NSf1 Holdings LLC · Darien, CTN413CGRegistered aircraftN413HAMap Transport LLC · Lexington, KYN419DFSwitch Ltd · Las Vegas, NVN420CCCooke & Cooke Air LLC · Nashville, TNN421SCStryker Corp · Portage, MIN422FJHca Squared LLC · Nashville, TNN427MJ427mj LLC · Hazel Crest, ILN428FJDassault Falcon Jet Corp · Little Ferry, NJN42STTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN431JABank Of Utah Trustee · Salt Lake City, UTN435JFJf Aircraft LLC · Detroit, MIN436CJet Coordination LLC · Saint Paul, MNN437JDAgrilease LLC · West Des Moines, IAN43RTRegistered aircraftN449SATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN44DNTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN44JCJm Cox Resources Lp · Midland, TXN453SBSierra Bravo Graco Inc · Emigrant, MTN454GBMarvin Leasing LLC · New Hope, MNN45EGApex Air LLC · Greenwood, INN45PKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN45RTRegistered aircraftN460SJDarby Holdings II LLC · Baltimore, MDN465RDMagnum 465rd LLC · Las Vegas, NVN466JCBank Of Utah Trustee · Salt Lake City, UTN468AMAmc 50 LLC · Chicago, ILN46ERegistered aircraftN46FRegistered aircraft
Back to AD 2002-23-19