AD 87-10-06 R1
Registered aircraft · 72,010
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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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.
N74088Mcgee Neil R · Littleton, NCN7408DTobin John C · Olympia, WAN7408JHiller Alex T · Lake Orion, MIN7408PJeffrey Thomas James · Crestwood, KYN7408RAdventures Aviation LLC · Whitehouse Station, NJN7408VM Twenty Inc · Bismarck, NDN74090Tiger Air LLC · Chatsworth, CAN74092Mcgill John G · Atlanta, GAN74094Eastern Shore Flying Service Inc · Wilmington, DEN74095Benson Edwin R · Gulfport, FLN74096Borden Lester N · Dalzell, ILN74099Sigg David · Bluffton, SCN7409DBartlett Donald R · Weirsdale, FLN7409GAero Quest LLC D/B/A · Olive Branch, MSN7409JAdp Consultants Inc · Laurel, MDN7409PPeters Gordon J · Salem, ORN7409ZFinger Lakes Soaring Club Inc · Dansville, NYFirst renewal noticeN740AMHawbaker Michael S · Warrenton, MON740CPCivil Air Patrol · Maxwell Afb, ALN740HCVuksanovic David A · Fountain Hills, AZN740HNBailey Roland L · Frazeysburg, OHN740HSSnook Harold F · Beaver Springs, PAN740NDUnd Aerospace Foundation · Grand Forks, NDN740PASkywest Leasing Inc · St George, UTN740RHUnited Helicopter Leasing LLC · Honolulu, HIN740UOhio University · Albany, OHN740WTCentral Valley Flight School LLC · Hanford, CAN74100Derby Kent E · Denver, CON74101Mickelsen Brian C · South Jordan, UTN74104Supan J T Trustee · Santa Cruz, CAN74105Lamphier Marc S · Lawrence, MAN74109Piscitello Thomas J · Yulee, FLN7410DHampton Michael D · Marshfield, MOFirst renewal noticeN7410JGeorge Ladelle · Ashley, NDN7410RElon Aviation LLC · Burlington, NCN7410WKlassen Peter K · Seminole, TXN7410YDuncan Paul J · Bartlett, TNN7411DMclain Joseph L · Louisville, KYN7411SNaik Narayan · Claremore, OKN7411VDk Aero LLC · Wilmington, DEN74127Richards Michael W · Lafayette, INN7412JDubois Aviation Inc · Chino, CAN7412PEspyess Aviation LLC · Sylvania, OHN7412RZembinski Robert A · Brookfield, WIN7412WRegistered aircraftRegistration pendingN7413DDraper Scott · Rutland, VTN7413JLittle Evin M · Bidwell, OHN7413RRegistration Pending · Gilbert, AZRegistration pendingN7413WRivera Genaro · Clarksville, TNN7413YOutka Air LLC · Aberdeen, SD
Back to AD 87-10-06 R1