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.
N955SKConcho Aviation LLC · Sterling City, TXN955SMCustom Concrete & Building LLC · Pleasantville, TNN955SPBarto Jerrel C · Kula, HIN955TMaynard Robert R · Inglewood, CARegistration revokedN9560JAdams Carl J · Conroe, TXN9560MPontarolo Michael A Trustee · Pacific Grove, CAN9560PJetran LLC · Horseshoe Bay, TXN9560SMoore Justin W · Hollywood Park, TXN9560VRegistration Pending · Big Spring, TXRegistration pendingN9560WGeneral Aviation LLC · Henderson, NVN9561CRak Flight Squad LLC · Bronx, NYN9561DHughey Randal P · Muskegon, MIN9561JScarlet Aviation LLC · Jonestown, PAN9561KRouth Kipp D · New Richland, MNN9561LWalter Terrance A · Pinckney, MIN9561MAck & Co LLC · East Helena, MTN9561VAbove And Beyond Aviation LLC · Austin, TXN9562BCharleston Flying Club LLC · Charleston, SCN9562HL & W Aircraft Investments LLC · Homestead, FLN9562JPosnett William L III · Lexington Park, MDN9562MPhillips Gary C · Midland, MIN9562PAvolant Aviation LLC · Mooresville, NCN9562QSilverhawk Aviation Academy Oregon LLC · Ontario, ORN9562UFoote Peter S · Lockport, NYN9562VWinged Winds LLC · Douglassville, PAN9562WHub City Aviation Academy LLC · Lubbock, TXN9563Marzich Frank M · Rockford, ILN9563AChristiansen Aviation LLC · Wilmington, DEN9563FClunie David A · Bangor, PAN9563LFite James · Victorville, CAN9563PTodd Doug A · De Witt, IAN9563WEastside Development Co Inc · Winfield, KSN9564CPowell David K · Edwardsville, ILN9564HLafleur Laurence J · Natick, MAN9564JIrvin Stephanie Michelle · Jacksonville, FLN9564MCheung Charlotte · San Jose, CAN9565Bailey Gordon J · Fayetteville, GAN9565JNebeker Kayla Rae · Murrieta, CAN9565MBitterroot Ventures LLC · Show Low, AZN9566BQualitair LLC · MichelstadtN9566DHerbert Brendan A · Portola, CAN9566HGarcia Mario · Yuma, AZN9566LNorth Sound Aviation · Sedro Woolley, WAN9566MRegistered aircraftAssigned, pending cancellationN9566VS D Enterprises Ltd · Brookhaven, NYN9567DFurois Alex D · Bridger, MTN9567HCurley Mark L · Alamosa, CON9567MArrowline Holdings LLC · Brookfield, CTN9567VBdc Aero LLC · Miami, TXRegistration expired, pending cancellationN9567WMiler Aaron L · Chambersburg, PA
Back to AD 87-10-06 R1