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.
N8496WKnapp Richard M · Dallas, TXN8496YOsiol Russell E · Chicago, ILN8497WAndrews James E Jr · Cantonment, FLN8498CAir Margarita · San Juan, PRN8498DBig Boy Business LLC · Oklahoma City, OKN8498FJones Teddy · Sevierville, TNN8498LWestern Slope Aviators LLC · Delta, CON8498RLangeland Carrol · Menno, SDN8498WPetry Scott A · Greenfield, INN8498YHaigh Joseph C · Rocky Ford, GAN8499BJackson Paul Douglas · Chesapeake, VAN8499DHolton Randall B · Folley Beach, SCN8499FArrow Inc · Rockford, MIN8499LKennedy Christopher S · Canton, ILN8499RZoss Curtis · Pensacola, FLN8499WNazif Ziad J · Denver, NCN849AAAb Prop Plane I LLC · Metairie, LAN849BTPeacock Group LLC · Clermont, FLN849CFEllison David B · Spotsylvania, VAN849GSEskridge William · Cheraw, SCN849WYYerxa W A DBA · Colusa, CAN84AMoss G B · Bakersfield, CAN84ABBald Eagle Aero LLC · Chesapeake, VAN84AGHillman William W · Oro Valley, AZN84AJPa-18 LLC · South Portland, MEN84ATJ Squared Enterprises Corp · Hendersonville, TNN84AVSyracuse Flying Club Inc · Fayetteville, NYN84BMMcminn Brian R · Rushville, INN84BZBeyerle Clinton D · Lake Havasu City, AZN84CBRegistration Pending · Buda, TXRegistration pendingN84DHStanton Mark I · Spokane, WAN84DJRuhnau Darren S · Park City, UTN84DLAirplanes And Helicopters Of Oregon LLC · Sisters, ORN84DWBuffalo Valley Aviation LLC · Neosho, MON84EBHodge Joseph Randall · Brenham, TXN84EDAms Aviation LLC · Brashear, TXN84EMPinegar Aviation Services LLC · Ridgeland, SCN84GGSweeney Jack R · Parker, AZN84GMCech Edward L · Grand Haven, MIN84GSAjluni Robert · Shreveport, LAN84GTDodson International Parts Inc · Rantoul, KSFirst renewal noticeN84HLLang Aviation Support Services LLC · Scottsdale, AZN84HWBerkbiegler Allen · Hardy, ARN84HXDriggers Group Inc · Saint Petersburg, FLN84HYH&A Aviation Lc · Hanover, VAN84JAAndre Joseph L · Puyallup, WAN84JDBeving Charles D · Garden City, SDN84JSKocak Robert G Jr · Peoria, AZN84KAEpix Air LLC · Worthington, MNN84KGGinz Peter M · Guilford, CT
Back to AD 87-10-06 R1