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.
N8942NMinnema Samuel S · Fairbanks, AKN8942PAncelet Grant D · Crowley, LAN8942VPilots Flying School LLC · Englishtown, NJN8943JHuber Steven C · Hernando, MSN8943NChase-Six LLC · Orange Park, FLN8943VZiegler Aviation LLC · Minneapolis, MNN8943WBlack Paul D · Auburn, CAN8944Bundy John F · Hamilton, MTN8944FFitzgerald Brian B · Gettysburg, PAN8944PPittner Hans C · Goshen, NYN8944YTallman Michael Daniel · Latrobe, PAN8945DSonnenberg Larry L · Huber Heights, OHN8945JFischer Thomas F · Troy, ILN8946Cox Paul Bartlett · Granbury, TXN89464Freeway Airport Inc · Mitchellville, MDN8946CPilawski Darren J · Spring Hill, FLN8946J2mec Holdings LLC · Kalispell, MTN8946PBreding Ralph E · American Falls, IDN8946VWings Over Texas Holdings LLC · Denton, TXN8946WBeck Adam J · Mulberry, INN8947NGarfield Air LLC · Burwell, NEN8947VMills Alan F · Chatom, ALN8947WWard Marcus K · Payette, IDN8947YStroh Chuck · Yukon, OKN8948CKrupnik Amnon · Bethesda, MDN8948FO Reilly Thomas P · Oscoda, MIN8948JAlbright Frank E · Ashley, INN8948NC6 Flying LLC · North Logan, UTN8948VPlain Company Ltd · Bloomfield Hills, MIN8948WGarrison Randy M · Plains, MTN8948YKilpatrick Kerry · Somerset, NJN8949CMorgan Aviation LLC · Greensboro, NCN8949JSchmidt Roger L · Plattsmouth, NEN8949WSullivan Sean · Fort Worth, TXN8949ZBills Mark W · Willow, AKN894ACAri Ben Aviator Inc · Fort Pierce, FLN894ALLancaster Wesley A · Saint Augustine, FLN894ARLayke Tool And Manufacturing Co · Meadville, PAN894CDSykes Richard D · Longmont, CON894FSMiller Dietrick J · Monte Vista, CON894MAHot Wings Aviation LLC · Indianapolis, INN894MJWaite Richard H · Sun Valley, IDN894MRAircraft Guaranty Corp Trustee · Oklahoma City, OKN894RVCox Aaron D · Kalama, WAN894YPodunk Planes LLC · Boulder, CON895Ghosh Abhimanyu · Mojave, CAN89503Menne Aviation LLC · Brooklyn Park, MNN8950FAloft · Haiku, HIN8950MPacific Flight Academy LLC · Honolulu, HIN8950NWatson Richard D · Plant City, FL
Back to AD 87-10-06 R1