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.
N7458DWheeler Evan L · North Pole, AKN7458JReeves Stephen · Watford City, NDN7458WMy Bird Is Bigger Than Yours LLC · Fort Myers, FLN74590Registration Pending · Barry, TXRegistration pendingN74591Tiger Aero LLC · Beresford, SDN74592Higgs III Cyrus H · Jackson, TNN74593Sandlin Jesse L · Chesterfield, VAN74594Pinger Kevin R · Palo Alto, CAN74595Ehrhard Robert A · Jasper, INN74596Cato James W · Las Cruces, NMN74597Airman Helicopter Inc · Fort Lauderdale, FLN74599Fletchair Inc · Comfort, TXN7459JEvans Charles Dewayne · Cumby, TXN7459LStewart Martin J · Anchorage, AKN745AALarson Stephen Blair · Raleigh, NCN745CWKnight Verl D · Caldwell, IDN745FWWalther Frank C · Crawford, CON745GCHill Jack C · Arnold, MON745LMMurley Stephen L · Boerne, TXN745LSWeaver Chris D · Hallam, NEN745MSSchamel Michael A · Salem, INN745NDUnd Aerospace Foundation · Grand Forks, NDN745PASkywest Leasing Inc · St George, UTN745RAAri Ben Aviator Inc · Fort Pierce, FLN745SPBanks Douglas Trent III · Huntsville, ALN745TWTumbleweed Leasing Co Inc · Salt Lake City, UTN745ZZin Services LLC · Dover, DEN746Hall Gary L · Delta Junction, AKN74600Tiger Flight Corp · Wilmington, DEN74602November Alpha LLC · Dover, DEN74606Spitzer Helicopter LLC · Woodland Hills, CAN74608Palmer Thomas R · Vincent, OHN7460DJohnston Stephen P · Hawley, MNN7460LLeoni Eric D · Boulder, CON7460PStevenson George Otis · Wheatland, WYN7460ZSimmons Aviation Services LLC · Pawcatuck, CTN74611Hahn Jordan A · Orcutt, CAN74613Lindstrom Richard T · Castro Valley, CAN74614Bikerman David J · Old Savbrook, CTN74619Specialty Aerospace LLC · Grand Rapids, MIN7461GKniphfer Krenson Hunter · Newington, GAN7461RIngram John · Tulsa, OKN7461WSdflysc LLC · Mauldin, SCN74620Columbia Flying LLC · Columbia, SCN74623Colibri Property Management Inc · Evergreen, CON74624Reagh Holdings LLC · Kalispell, MTN74625Brotherton Bradley T Trustee · Canby, ORN74628Hess Steven P · Menahga, MNN74629Ltc Enterprises Inc · Wilmington, DEN7462JFirmino Paulo · Gainesville, TX
Back to AD 87-10-06 R1