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.
N661MLDap Aviation LLC · Baton Rouge, LAN661NDUnd Aerospace Foundation · Grand Forks, NDN661PBravo Tango LLC · Minden, LAN661PC661pc LLC · New Rockford, NDN661QS&S Aircraft Inc · Bennington, VTN661RRHelicopter Of Columbia LLC · Columbia, SCN661RVVans Rv6 Flyer Inc · Auburn Hills, MIN661SDDarr Henry S · High Point, NCN6620CDieck Steven L · Lake Villa, ILN6620DPacific Fleet Aviation LLC · Rochester, NYN6620LMc Gregor Daniel A · Denali Park, AKN6620PMagel David J · Lakemoor, ILN6620RWhite Richard C · Tracy, CAN6620VHall Steven R · Cambridge, MAN66213Global Adventures N66213 LLC · Hollywood, FLN66215Channel Islands Aviation Inc · Camarillo, CAN6621DCosta Air Service LLC · Painted Post, NYN6621JMardis David P · Warner Robins, GAN6621PR C Antique Aviation LLC · Saint Louis, MON6621RRasmussen Paul A · Lakewood, CAN6621WGbg Aviation LLC · Foristell, MON6621YDyka Samuel M · Flushing, MIN6622DArq Aviation LLC · Wilmington, NCN6622JBernstein Matthew D · North Charleston, SCN6622UArmistead Jack R · Birmingham, ALN6622WBayko John T · Marengo, OHN66230East Hill Flying Club Inc · Ithaca, NYN6623JAcadian Aviation Pilot Training Centre Inc · Lafayette, LAN6623PHopkins Daryl L · Gentry, ARN6623YOrtner Airport LLC · Wakeman, OHN6623ZMage Aircraft Leasing LLC · San Antonio, TXN6624ARegistered aircraftN6624GBob Hoover Academy · Salinas, CAN6624HSakata Lissa C · Falls Church, VAN6624JN6624 LLC · Reserve, LAN6624PMiller David J · Washington, IAFirst renewal noticeN6624VDahle Jeffrey R · Ashland, ORN66251T Air LLC · Bonita Springs, FLN6625DFox Valley Technical College · Oshkosh, WIN6625JJustice Andrew C · Amory, MSN6625WR W Bright Architects Inc · Tulsa, OKN6626DDrozs Allen P · Decatur, ILN6626JSn Aviation LLC · Richardson, TXN6626UCramer Brett E · Sloughhouse, CAN6627JYellowstone Flying Club · Billings, MTN6627PMaddela Prabhuvaram J · El Mirage, AZN6627WSemprimoznik Jeffery J · Davenport, WAN6627YMiller Jay M DBA · Grantsville, MDN6628EPhillips Alan K · Junction City, ORN6628JSiusta Donald W · Bryceville, FL
Back to AD 87-10-06 R1