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.
N9658FFerguson William T · Fayetteville, TNN9658KFlying Particles Inc · Livermore, CAN9658MReames B Robert Jr · Six Lakes, MIN9658URegistration Pending · Spencer, NERegistration pendingN9658WGraham Joel A · Marietta, GAN9659HJd Griffin LLC · Wilmington, DEN9659KBell Michael J · Duck Key, FLN9659LMoffatt Thomas · Dallas, GAN9659QMacrafic Bruce A · Garden City, MNN9659SRandall Timothy J · Skidmore, MON9659WMitchell Matthew · Ypsilanti, MIN965ACNaples Air Center Inc · Naples, FLN965BJNorton Raquel D Trustee · Stateline, NVN965CWAir Capital Aviators Club · Wichita, KSN965CZStadler Frederic L · Oshkosh, WIN965JBKeevair LLC · Rockaway, NJN965JDCircling Sky Aviation LLC · Canton, MSN965MAFirst Aero Group LLC · Wilmington, DEN965MMBastian Devan · Vernal, UTN965MSMt San Antonio College · Walnut, CAN965TBRaissiguier Jacques · Fort Lauderdale, FLN9660BHenry Lawrence D · Lohman, MON9660HCdb Group Holdings LLC · Sheridan, WYN9660MKnight Aviation LLC · Comanche, OKN9660PCook Timothy L · Eagle River, AKN9660WAlaimo Thomas J · Napa, CAN96616Air Transport Inc DBA · Las Vegas, NVN9661JGrant Michael T · Eugene, ORN96621D Gordon Aviation Inc · La Jolla, CAN96626Wingsleasing LLC · Wichita, KSN96628Bobby Nelson Aviation LLC · Kettering, OHN9662MPotter Colin · Piedmont, SDN9662QHomiller Robert S · Bear, DEN9662UT & J Services Inc · Wilmington, DEN9662VLevel X Aviation LLC · Royal Palm Beach, FLN9663DRamsey Bobby W · Harrogate, TNN9663JN9663j LLC · Dallas, TXN9663PDilse Brian R · Grand Forks, NDN9663UMaxfield Ronald · Mechanicsville, VAN9664MProvide It Air Solutions LLC · Tampa, FLN9664PYundt Joshua J · Wasilla, AKN9664UBoan Timothy C · Berryville, VAN9665FFranklin Charles L · Athens, ALN9665HDouble Bridges Aviation LLC · Enterprise, ALN9665JUmbarger Brian T · Shawnee, KSN9665MMr Aviation Group LLC · Mifflintown, PAN9665QAlldredge Aviation · Auburn, WAN9665UDurning Robert · Riddle, ORN9665VAircraftsmen LLC · Heber City, UTN9665WSoto Osvaldo · Myersville, MD
Back to AD 87-10-06 R1