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.
N767DPBeardsley William A · Tracy, CAN767ERJet Stream Jockey LLC · Venice, CAN767EWShaffer Jon Michael · Colorado City, CON767FTRenner Brian E · North Port, FLN767GGabbard Michael · Jupiter, FLN767GCKiernan Eric J · Bozeman, MTN767GLShemo George T · Newnan, GAN767GPGoodwinds Aero LLC · Roseburg, ORN767JGKd Aviation LLC · Perry, GAN767JMMc Kiernan John E · Navarre, FLN767JSStarr Jeffrey J · Naperville, ILN767JWRoads End Aero LLC · Erwinna, PAN767KLLowrance Kathleen C · Port Orange, FLN767KPPhill-Air Inc · Dover, DEN767KTStitch And Purl LLC · Sparks, NVN767LRegistered aircraftN767LAN767la LLC · Philadelphia, PAN767LWMiller Wayne L · Santa Monica, CAN767MDAir Meg LLC · Redington Beach, FLN767MTDouglas Machinery LLC · Saint Francis, SDN767NTognoli Steve F · Union, ORN767NDUniversity Of North Dakota · Grand Forks, NDN767PAviation Investments Inc · Virginia Beach, VAN767PAPurdue Aviation LLC · West Lafayette, INN767PEDaytona Aircraft Leasing LLC · Daytona Beach, FLN767PMMccord Paul F · Indianapolis, INFirst renewal noticeN767RCTalarik Air LLC · Memphis, TNN767RJS&S Aircraft Inc · Bennington, VTN767SCClegg Stephen A · Port Orange, FLN767SECoyote Aviation LLC · Carefree, AZN767TBOx Aviation LLC · Monmouth, ORN767TCTc Aviation Ltd · Fairbanks, AKN767WDLibby William J · Hooksett, NHN767WMMcmaster Wayne R · Jeffersonville, INN767XRegistered aircraftN7680DHart Gary L · Fernwood, IDN7680FMag Avionics LLC · Woodlands, TXN7680GGulyash Michael J · Ukiah, CAN7680RPotter Steven R · Grapevine, TXN7680SHallsten Stephen B · Fairbanks, AKN7680WMearbell Kevin J · Niagara Falls, NYN7681GCompass Aviation Inc · Shelby, NCN7681SCawley Jeffrey W · Buckley, WAN7681YTaft Aviation LLC · Brookhaven, NYN7682DMckay Don · Soldotna, AKN7682JAv Serv LLC · Dover, DEN7682MVan De Hei Mike · Pioneer, CAN7682RTrull Stephen G · Golden Valley, MNN7682WMcintosh Doyle · North Ogden, UTN7683DYellow Bird Inc · Doral, FL
Back to AD 87-10-06 R1