AD 2002-01-23
Registered aircraft · 329
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-01-23')
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-01-23')
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-01-23') 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-01-23') 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.
N400MXRjb Management Company Inc · Moon Township, PAN400PKN400pk Leasing LLC · Wichita, KSN400PVRk-263 Leasing LLC · Benton, KSN400RGN400rg Leasing LLC · Wichita, KSN400RYRegistered aircraftN400SMN400sm Leasing LLC · Wichita, KSN400TCMorning Star Aviation LLC · Indianapolis, INN400TUN400tu Leasing LLC · Wichita, KSN400UFNova Jets USA Corp · Orlando, FLN400VPN400vp LLC · Wilmington, DEN400WFTwo Rivers Aviation LLC · Wichita, KSN400XClemens Aviation LLC · Wichita, KSN400XAN400xa LLC · Wichita, KSN400XCN400xc Leasing LLC · Wichita, KSN400XPLdm Holdings Inc · Dansville, NYN400XRN400xr LLC · Wichita, KSN400ZZN400zz Leasing LLC · Wichita, KSN401BCNextant Sn 36 LLC · Boca Raton, FLN401RLGuardian Pharmacy LLC · Atlanta, GAN401XRBank Of Utah Trustee · Salt Lake City, UTN402FBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN402XTGuntrack Aviation LLC · Castle Rock, CON404BCRk276 LLC · Gary, INN404LRSkyknight LLC · Greeneville, TNN404MSAir 121 LLC · Jacksonville, FLN405MGKm Operations LLC · Alpharetta, GAN407CWCorporate Wings LLC · Richmond Heights, OHN407TCTjtwo LLC · Nashville, TNN408MLAem Air LLC · Coral Gables, FLN40DXAmericanus Transport LLC · Sunrise, FLN410LGGrove City Aviation LLC · Mercer, PAN412GJAlliance Aviation Group LLC · Wilmington, DEN412TSHxp LLC · Wilmington, DEN414HVKitty Hawk LLC Trustee · Fort Worth, TXN418CTMmu Aviation LLC · West Orange, NJN418GJAlliance Aviation Group LLC · Wilmington, DEN419TMRelentless2012 LLC · Tampa, FLN41CGN41cg Leasing LLC · Wichita, KSN424SKCentral Iowa Aviation LLC · Ankeny, IAN425BJDodson International Parts Inc · Rantoul, KSN428HPHighland Paving Co LLC · Eastover, NCN432MAFwj Aircraft LLC · Columbus, GAN436FLFlight Options LLC · Cleveland, OHN43BDMr3 Air LLC · Cincinnati, OHN440JRHilsinger Aviation LLC · Climax, NCN440LNBlue Horizon Point LLC · Lewes, DEN440TATeam Aero LLC · Shawnee, KSN440XTL C Whitford Co Inc · Wellsville, NYN442EAAziz Walid George Haddad · San Antonio, TXN442GJFirm Foundation Aviation LLC · Brea, CA
Back to AD 2002-01-23