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.
N6469WPivotal Aviation LLC · Spartanburg, SCN646DGFulton Todd C · Sacramento, CAN646FBBourque Ronny Joseph Marc · Santa Maria, CAN646FLTaylor William L · Fairfield, ILN646FTFlorida Institute Of Technology · Melbourne, FLN646HStyer David B · Milton Freewater, ORN646JMChapman Johnny Darrell · Douglasville, GAN646KWHely Aviation LLC · Columbus, INN646NDUnd Aerospace Foundation · Grand Forks, NDN646RVImagine Air LLC · Nogales, AZN646SAAbc Aviation LLC · Floresville, TXN646SBBurris Chris E · Larned, KSN646SDBiton Liad · San Diego, CAN646SPVermeylen Donna Lynn · Altamont, TNN6470JSitlinger Angela R · Gratz, PAN6470RAlterio Mark G · North Andover, MAN6470WO'Kelly Albert · Caruthers, CAN6470ZNorthern California Soaring Association · Byron, CAN64717Top Aviation Services Inc · Weston, FLN6471JMartinez Paul · Sonora, TXN6471PWare Patrick D · Farwell, TXN6471QNugent Todd · Lake Bluff, ILN6471RStraw Robert D · Farmington, MNN64728Systir Aviation LLC · Pittsburgh, PAN6472JFAA Flying Club Inc · Springfield, VAN6472QCornay Louis J Jr · Franklin, TNN6472RWilson Richard J · Naknek, AKN6472WSilaban Chandra · Independence, KYN6472YNorman Robert Alan · Zanesville, OHN64732A And J Aviation Services LLC · Okeechobee, FLN64736American Patrols Inc · Midland, TXN64739Registered aircraftN6473DTurner Glenn · West Melbourne, FLN6473UCardinal Exploration LLC · Northville, MIN6474JBenham Miriam · Elk Grove, CAN6474QSale Reported · Sarasota, FLSale reported, canceledN6474ZKoenig Donald J · Las Animas, CON64754Aerofeather Aviation Inc · Suffolk, VAN6475DDarcy Aviation LLC · Danbury, CTN6475JClark Clyde E · Naknek, AKN6475LTerra Flight Aerial Imaging Inc · Spring, TXN6475UVermilyea Ian · Pensacola, FLN6475WJ K Merrill And Sons Inc · Pocatello, IDN6476GChupito Sabrocito LLC · Paso Robles, CAN6476PSky Runner Aviation LLC · Wadsworth, OHN6476QPacheco Enrique Roman · Albuquerque, NMN6476RVlaz Richard J · Washington Twp, MIN6476TAngel Air Ltd · Smithvile, OHN6476UFoster William B Jr · Chickasha, OKN64776Christiansen Aviation LLC · Wilmington, DE
Back to AD 87-10-06 R1