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.
N8270PKraemer And Co Mfg Inc · Orland, CAN8270WRegistration Pending · Fair Oaks Ranch, TXRegistration pendingN82712Flack Andrew P · Wasilla, AKN82714Gross Jeffrey A · Tok, AKN82718Hanley Company LLC · Littleton, CON82719Doitch Dan · Valencia, CAN8271LLanni David L · Fairbanks, AKN8271VCkt3 LLC · Kalispell, MTN8271WWashington Aero Club · South Park, PAN8271YWhitley Miles G · Olathe, KSN82720Skydove Ministries LLC · Glenmoore, PAN82723Dodson International Parts Inc · Rantoul, KSN82725Sherman Guy F · Soldotna, AKN82727Gregory John R · Challis, IDN8272ASt Germain Michael · Bakersville, NCN8272CHaeuser August A · Stowe, PAN8272FMidwest National Flying Club Inc · Gladstone, MON8272HMorten Jesse L · Larimore, NDN8272VSkybound Aviation LLC · Greensboro, NCN82731Hoecher Chris · Greeley, CON82732State Of Alaska · Anchorage, AKN82735State Of Alaska · Anchorage, AKN82736State Of Alaska · Anchorage, AKN82737Swiss Jack S · Anchorage, AKN8273AElon Aviation LLC · Burlington, NCN8273DDemuth John L · Juneau, AKN8273NSomboonsap Patanapong · Oakland Park, FLN8273VArctic Fox Aircraft LLC · Queen Creek, AZN82740Thomas Timothy W · Watsonville, CAN82741Stancil Joseph E Jr · Eagle River, AKN82743Up And Away Aviation LLC · Poughkeepsie, NYN82748Templeton Marie K Trustee · Carthage, MON82749Habersetzer Lon J · Yacolt, WAN8274EChristiansen Aviation LLC · Wilmington, DEN8274HThunderbird Aircraft Co · Bloomington, MNN8274JHunt Tyson B · Saratoga Springs, NYN8274NJln Aviation Services LLC · Avon, INN8274PVenticinque Raymond A · Cranston, RIN8274VSage Tech Flight Club LLC · Underwood, WAN8274WSleight Travis A · Southfield, MIN8274XBrown Archie W · Milford, NHN8274YTwinkie Transport LLC · Palm City, FLN82750Jabour Virginia · Port Orange, FLN82751Fly49 LLC · Palmer, AKN82754Lee Nathan · Athol, IDN82757Registration Pending · Fairmont, WVRegistration pendingN8275DMoore Aviation Inc · Beaver Falls, PAN8275HMontgomery Aviation Corp · Montgomery, ALN8275JFlabob Airport LLC · Riverside, CAN8275NRollinger Dennis P · Plainfield, IL
Back to AD 87-10-06 R1