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.
N8824JJohnson Lawrence F · Ancorage, AKN8824NDale Keith Wayne · Gurdon, ARN8824PAzimi Matthew H · Navarre, FLN88252Schell Joseph H · Granbury, TXN88256Greensted Richard E · Anchorage, AKN88258Ohlman Terry · Franktown, CON8825AGauges Green LLC · Euless, TXN8825JAlexander Carol E · Pineville, LAN8825NMissouri River Flying Club LLC · Mandan, NDN8825WSires Mark Steven · Lake City, FLN8825ZDisrud Roger G · Olathe, KSN88264Summers Philip A · Fairbanks, AKN88265Reiner Buck · Fishtail, MTN88266Kraxberger Rick R · Kasilof, AKN88268Neidert Melvin E · Ulysses, KSN8826DSongster Kevin M · Friend, NEN8826NWg Aviation LLC · Shippenville, PAN8826PIngalls Equipment LLC · Redlands, CAN88273Pettijohn Patton D · Wasilla, AKN88276Straten Oliver · Wasilla, AKN88277Reid Paul E · Firth, IDN88278Crosswell Joe D · Springtown, TXN88280Lazareanu Sorin D · Apex, NCN88281Auten James W · Stratford, CTN88287Meyerkorth Aviation LLC · Rock Port, MON88288Cain Philip K · Escondido, CAN8828FJohnson Martin L · Agua Dulce, CAN8828VStebner William R · Crossville, TNN88290Outer Banks Seaplanes LLC · Manteo, NCN88297Naber David Lowell · Fairbanks, AKN8829DSchwenninger Ronald L · Allison Park, PAN8829PInternational Air Services Inc Trustee · Carson City, NVN8829WDernbach Richard M · Glenbrook, NVN882ATDot Aviation LLC · Wilmington, DEN882BKRegistered aircraftN882FDrb Helicopters LLC · Klamath Falls, ORN882FCFlying C Aviation Inc · Searcy, ARN882GHunt David Gregory Trustee · San Diego, CAN882JHSouthern Aircraft Consultancy Inc Trustee · Casper, WYN882KMMatheny Robin M · Titusville, FLN882LBArizona Flyers Club Inc · Tucson, AZN882MASmith David E · Green Valley, AZN882PDEdwards Charles Steve · Fowler, KSN882RVCrissinger William M · Carl Junction, MON882SPRegistration Pending · Santa Fe, NMRegistration pending, canceledN882WPSouth Florida Oasis LLC · Weirsdale, FLN88303Airplanes LLC · Springfield, ORN88305Loprinze Aviation LLC · Nashua, NHN88306Shaw David H · Nenana, AKN88307University Of Alaska Anchorage Aviation Technology · Anchorage, AK
Back to AD 87-10-06 R1