AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
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:2007-04-19-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') 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.
N3797QKolb Norman R · Tijeras, NMN3797TMarshall Patrick R · Trail, ORN3797WCarter Thomas Shane · Pinetop, AZN3797YCockroft Roger · Baltimore, MDN3797ZMerriner Scott L · Anchorage, AKN3798KCrosswind Aviation Of Oklahoma LLC · Stillwater, OKN3798QMartin-Fosters Fuel Service Inc · Seminole, OKN3798UClapper Wesley J · Spokane, WAN3798ZLovett William E · Homer, AKN3799GRounds Chris · Waller, TXN3799KVea Lynn B · Mokena, ILN3799MWaldron Ronald · Strongsville, OHN3799NCarlson John W · Wichita, KSN3799PCt Services LLC · Albuquerque, NMN3799QDtb Aviation Inc · Los Gatos, CAN3799TFly 99t LLC · Pompano Beach, FLN3799XWilson Ricky A · Santa Teresa, NMN3799ZConley Clint A · Spring Creek, NVN379BLBlue Line Aviation LLC · Smithfield, NCN379BTPiper Aircraft Inc · Vero Beach, FLN379CCSmith Jason · Calliham, TXN379CDOptimal Aircraft Management Mi LLC · Sanford, MIN379GSSmith Adam · Rose Hill, KSN379HHack John C · Hobart, INN379JTN379jt LLC · Spokane, WAN379LAM&K Commercial Diving LLC · Fair Haven, VTN379MATurtle With Wings LLC · Yukon, OKN379MCAvex Holdings Heli Inc · Lewes, DEN379NARonneberg Dave H · Santa Monica, CAN379NDUnd Aerospace Foundation · Grand Forks, NDN379NLDe Av8r LLC · Lewes, DEN379PFRegistered aircraftN379SSky Chasers LLC · Mount Vernon, WAN379SVSahara Viking Aviation LLC · Ocoee, FLN379TCherney Cody L · Belleville, KSN379TAChuck Smith Aircraft Inc · Torrance, CAN379TWTanglewood Aviation LLC · Fort Mill, SCN379XCjr Air Service LLC · Saint Louis, MON37AGWalker Robert J · West Finley, PAN37ARFlowers Charles L · Yelm, WAN37AWCcx-2000-0111 LLC · Garberville, CAN37BAAmbler Robert L · San Diego, CAN37BCBarnes David L · Palmer, AKN37BHHuelsman Bradley D · Dayton, OHN37BKChanging Horizons LLC · Helena, MTN37BRC&D Pharmaceuticals Berry Inc · Berry, ALN37BSMatthew Davis · Asheville, NCN37BTStucki Andre O · Deerfield Beach, FLN37BYTubreaux Aviation Services LLC · Shreveport, LAN37CHDehaan Aviation LLC · Bethel, AK
Back to AD 2007-04-19 R1