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.
N26142Stamper George William III · Quinton, VAN2614DRegistration Pending · Kerrville, TXRegistration pendingN2614FWissenbach Richard G · Pinesdale, MTN2614GNorthern Air Inc · Bonners Ferry, IDN2614LCharter Flights Caribbean Inc · San Juan, PRN2614QBeyers Donald · Pana, ILN2614RWindh Steven R · Reedley, CAN26156Hyannis Air Service Inc · Hyannis, MAN2615GHyannis Air Service Inc DBA · Hyannis, MAN2615QVenture Air Solutions Inc · Opa Locka, FLN2615RWolf Coy D · Ord, NEN2615WSturgis Joel B · Pensacola, FLN2615ZCalhoon John Charles · Woodinville, WAN26160Wilson William J · Houston, TXN26163Brown Michael D · Elk Grove, CAN26165Moldt Richard W · Montrose, CAN26167Mowery Ronnie G · Spencer, OHN2616FNotziger Shawn M · Lilburn, GAN2616QSutton Marshall T · Erick, OKN2616SMontana Alpha Omega Ranch LLC · Miles City, MTN2616WDenney David W · Fowler, CON26172Flying Tigers Flight School Ltd · Houston, TXN26179Richardson James D II · Bend, ORN2617GGandiaga Philip J · Buhl, IDN2617QKerhulas Anthony B · Santa Maria, CAN2617RFener Seth M · Claremont, CAN2617X2gl P&I LLC · El Paso, TXN2617ZCroy Branden J · Kendallville, INN2618GEagle Mountain International Church Inc · Newark, TXN2618LFl & J Air Corp · West Orange, NJN2618PHenningson Terry · Centennial, CON2618RMelton Edward A · Glendale, AZN26195Bradley Mark R · Brush Prairie, WAN2619DInman Steve · Billings, MTN2619FHayes Barrett W · Siler City, NCN2619GDodson International Parts Inc · Rantoul, KSFirst renewal noticeN2619LAircraft Holding Solutions LLC Trustee · Newark, DEN2619PColdsmith Steven L · Chambersburg, PAN2619QHoman Edward L · Cincinnati, OHN2619RRickert & Son LLC · Moses Lake, WAN2619WSmith Cecil · Fort Pierce, FLN2619XBrume Shawn O · Fairbanks, AKN2619Z4j Air LLC · Cartersville, GAN261AMeridian Aircraft LLC · Wilmington, DEN261AARoy Michael W · Pear Valley, TXN261AFState Of Louisiana · Baton Rouge, LAN261ALCkm Aircraft Holdings I LLC · Mandan, NDN261APRotor Leasing LLC · Indianapolis, INN261BWPiper Aircraft Inc · Vero Beach, FLN261CACivil Air Patrol · Maxwell Afb, AL
Back to AD 2007-04-19 R1