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.
N698HNelson Bobby E · Naples, FLN698MBravo Zulu International Ltd · Las Vegas, NVN698MADaher Michael P · Trabuco Canyon, CAN698SHMccair LLC · Mineral Wells, TXN698SPFoothill Aircraaft Sales & Service Inc · Upland, CAN698VWSheppard Louis A · Queens Village, NYN6990BE T Wells Inc · Helena, ARN6990DHorn Paul · Kodiak, AKN6990WMadichar LLC · Lempster, NHN6990ZWabash Valley Soaring Association Inc · Lawrenceville, ILN6991HRhinelander Flying Service Inc · Palmetto, FLN6991UHochstein Scott J · Skiatook, OKN6991WCarnes James Oscar Jr · Smiths Grove, KYN6992EMikkelsen John P · Sebastopol, CAN6992RBanana River Aviation LLC · Merritt Island, FLN6992ZSoaring Club Of Houston Inc · Waller, TXN6993BFarneski Robert B · Fairbanks, AKN6993JCannon Maureen A · Wareham, MAFirst renewal noticeN6993URamirez Arturo A · Lake Creek, TXN6994JLytle Tobin A · Grove, OKN6994PHunt Ray A · Louisburg, NCN6994QGronewold Dale A · Gothenburg, NEN6994URegistered aircraftN6994VKroutil David W · Hilmar, CAN6994WCone Carl T · Statesboro, GAN6995BChase Kenneth W · Anvik, AKN6995CDetert Bradley · Valparaiso, INN6995DZimmerman Christian · Anchorage, AKN6995PInternational Air Services Inc Trustee · Carson City, NVN6995RFeher Tara A · Chesapeake, VAN6995VHausmann Internaational Inc · Sugar Land, TXN6996AGrape Soda Adventures LLC · Weddington, NCN6996BAafedt Aaron B · Belgrade, MTN6996DByrd David P · King Salmon, AKN6996HWeirich Gayle M · Rockford, MIN6996PWelling Charles E III · West Islip, NYN6996UHanrahan William P · Seward, AKN6996WGiles David · Augusta, GAN6997DM & M Farms · Fowler, KSN6997JBailey Kevin R · Crown Point, INN6997RTimmons Tracy · Jacksonville, ILN6997UDoull Leyla · Miami, FLN6997WKeeter Michael P · Proberta, CAN6998BKoch Michael L · Neosho, WIN6998JMt Aircraft Sales And Leasing LLC · Wilmington, DEN6998NPacifica LLC · Grand Junction, CON6998PProven Frederick A · Hammond, NYN6998WTutunik Aleksandr · Lake Hughes, CAN6999Mccown Robert D · Eagle River, AKN69997Mckenney Bret · Billings, MT
Back to AD 87-10-06 R1