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.
N8920JSargent Timothy E · Pickerington, OHN8921DPetterson Jason G · Albert Lea, MNN8921POwens Gregory E · Kendallville, INN8921RPotters Aviation LLC · Haskell, OKN8921VN2827n LLC · Pembroke Pines, FLN8922Culver Marc D · Anchorage, AKN8922DHassell Clark R · Ketchikan, AKN8922JTowner Jeffery D · Rose Hill, KSN8922NKew Malcolm M · Hercules, CAN8922VTampa Bay Aviation Inc · Clearwater, FLN8923Brockway Troy D · Salina, KSN8923DWood Rhonda R · Livermore, CAN8923JVenture West LLC · Mesa, AZN8923NMiller Jarred J · Burton, OHN8924DHickey Aero Services LLC · White Hills, AZN8924NRobinson Andrew · Auburn, CAN8924VDupree Johnny · Crossett, ARN8924WRiblet Jeffrey L · Portsmouth, VAN8924YPrestininzi Robert Anthony · Fort Mill, SCN8925FAztec Aviation · Geneseo, ILN8925NMackay James R · Corunna, MIN8925PGriffith James E · Gig Harbor, WAN8925YBlue Sky Adventures LLC · Hanover, PAN8926Johnson David H · Jasper, GAN8926DPlanes & Things Inc · Collinsville, OKN8926JGreene Ronald F · Mc Alpin, FLN8926VCareer Flight Training And Aircraft Rental LLC · Naples, FLN8927JTipton Thomas G · Walnut Grove, MON8927NHoffman Gary D · Spencer, NEFirst renewal noticeN8927VTropical Aviation LLC · Gulf Shores, ALN8927WFiihr Travis A · Grand Junction, CON8928Anding Jay B · Bryan, TXN8928FDenver Aerospace Science Museum · Watkins, CON8928JHaybron David M · Sewickley, PAN8928MKeyt Jeffrey D · New Providence, NJN8928PGeorg John B · La Crosse, KSN8929Cavanagh James B · Litchfield Park, AZN8929JRice Spencer F · Portland, ORN8929LPeters Nicholas J · Eagle River, AKN8929WSimmons Ralph R Jr · Sadler, TXN892ACAri Ben Aviator Inc · Fort Pierce, FLN892BVGd Aviation Inc · Belleair, FLN892DLBd Aviation LLC · Sauget, ILN892MPlyler Aviation Lp · Sherman, TXN892MMWings Of Dubuque LLC · Dubuque, IAN892PTTims Duane R · Hemet, CAN892RCSmw-Cjh Corp · Wilmington, DEN892SGCraik Evelyn June · Las Vegas, NVN892TGTeo Steel Inc · Ramer, TNN892TWTeo Steel Inc · Ramer, TN
Back to AD 87-10-06 R1