AD 2002-17-53
Registered aircraft · 6,266
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-17-53')
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-17-53')
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-17-53') 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-17-53') 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.
N116GWMajestic Airlines Inc DBA · Lynden, WAN116MFWeber Donald E · Saint David, AZN116RCMiesch Gary D · Gowen, MIN116SMArchie Aero LLC · Beaverton, ORN1175KOkmok Aviation LLC · Anchorage, AKN1176AJar Air LLC · Incline Village, NVN1176ZAirborne Support Inc · Bourg, LAN117APAutumn Horizons LLC · Redwood City, CAN117BMManeck Aviation LLC · Columbus, GAN117GHAircraft Guaranty Corp Trustee · Oklahoma City, OKN117KRFox Planes LLC · Sterling Heights, MIN117SEHalsell Jason · Wolfforth, TXN117TDGiffin Craig D · Windermere, FLN1180XK & K Aero Inc · Wilmington, DEN1182DDura-Built Of Delaware LLC · Lewes, DEN1184NErickson Holdings LLC · Atlanta, GAN1187TBluenose LLC · Queen Creek, AZN1189WVan Bortel Aircraft Inc · Arlington, TXN1189YRegistered aircraftN118ESCmv Aviation LLC · Johnson City, NYN118JGRopewalk Investments LLC · Wilmington, DEN118MCAlpha Whiskey 3 LLC · Brandon, MSN1197LBoothe Vincent A · Fairhope, ALN119CACivil Air Patrol · Maxwell Afb, ALN119CRSchaeffer Cox Carla L Trustee · Newberg, ORN119CSVan Bortel Aircraft Inc · Arlington, TXN119GSDall James R Jr · Hayes, VAN119KRc Stone LLC · Willacoochee, GAN119PMMisunas Peter V Trustee · Redondo Beach, CAN11BHHarbold Norris Brown Jr · Lake Wylie, SCN11CGComanche 260b-N11cg · Pomeroy, WAN11HWSky West Aviation Inc Trustee · Albuquerque, NMN11KXN11kx LLC · Santa Clara, CAN11LJHandyquick Mn LLC · Woodbury, MNN11MPAtwill Brock · Paragould, ARN11PZCentral Virginia Flyers LLC · Palmyra, VAN11UTMax Aviation LLC · Venice, FLN11ZDQualitair LLC Trustee · MichelstadtN1202HAdams Aviation Services Inc Trustee · Wilmington, DEN1204CCarvilles Auto Mart · Grand Junction, CON120DGBluesail LLC · Las Vegas, NVN120DMWestfall Aviation LLC · Reno, OHN120FWRaabe Travel LLC Series 1 · Whitehouse, TXN120JDLamb Aviation LLC · Perris, CAN120LPGramer Air IV LLC · Northville, MIN120MLMrl Aviation LLC · Wilmington, DEN120PTPi Air LLC · Malibu, CAN1218WOndrick Aviation LLC · Chicopee, MAN121GHSunset Aviation LLC · Huntington, INN121GSHarrison Stephen D · Atwater, CA
Back to AD 2002-17-53