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.
N574MMMyers Benny R · Wasilla, AKN574MTGrow Michael J · Palmer, AKN574NDSunrise Aviation Inc · Ormond Beach, FLN574PRSoto Angel L · Las Piedras, PRN574RBGod'S Country Aviation LLC · Trapper Creek, AKN574RHRob Holland Ultimate Airshows LLC · Coushatta, LAN574RJJets To Helis LLC DBA · Chandler, AZN574SBRj Group Investments LLC · Lawton, OKN574STState Of Alaska · Anchorage, AKN574TMcallister Todd K · Grangeville, IDN574WBDeal Timothy E · Anchorage, AKN574WDLathrop Frederic W · Dayton, OHN57503Martin William A · Nashville, TNN57505Archipelago Group Llcc · Alexandria, VAN5750KSamons David M · Phoenix, AZN5750MStites Holdings LLC · Seattle, WAN5750PRoberts Donald W · Flower Mound, TXN5750QMelnyk Richard V · Uniontown, PAN57515Peterson Dean · Gothenburg, NEN57517Du Aircraft Leasing · Green Bay, WIN57519L & L Flying Inc · Glen Allan, MSN5751BMacon Michael D · Sisters, ORN5751EFlight Tech Inc · Arlington, WAN5751JB & H Drilg · Winnsboro, LAN5751KDetloff Martin P · Kaukauna, WIN5751PKrager Aviation LLC · Perry, UTN57522Baker Brad L · Salcha, AKN5752BWallace Thad Joseph · Mount Shasta, CAN5752MColeman William J · Redondo Beach, CAN5752QJackson John E · Oak Harbor, WAN5752URiggin Flight Service · Madison, SDN57532N57532 LLC · Wasilla, AKN57534Sale Reported · Drake, NDSale reported, pending cancellationN5753FRauch Jack · San Rafael, CAN5753KSale Reported · Fort Worth, TXSale reportedN5753WRegistration Pending · Royse City, TXRegistration pendingN5753ZFereday Richard R · Mccall, IDN5754DRocca John · Box Elder, SDN5754ECox Charles C · Hood River, ORN5754FStorm Joseph K · Enumclaw, WAN5754QHamm Martin C · Southport, NCN5754UAuthement Michael Ray · Pecos, TXN5754VWeiser Steven Clark · Hutto, TXN57550Freese Marc Alan · Fulda, MNN57555Norden Paul E · Anchorage, AKN5755DNathan Timothy A · Arnold, MDN5755GDestination Alaska Air Service LLC · Homer, AKN5755JBagge John A · Independence, IAN5755KBrooks Auto Parts Inc · Douglas, GAN5755UKyzer Aviation Holdings LLC · Fort Mill, SC
Back to AD 2007-04-19 R1