AD 87-20-03 R2
Registered aircraft · 54,015
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-20-03-R2')
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-20-03-R2')
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-20-03-R2') 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-20-03-R2') 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.
N97058Whizbang Flyers LLC · Houghton Lake, MIN9705BRovey James A · Troy, IDN9705HMillers Oak Island LLC · Crosslake, MNN9705ZDavis Bob F · Helena, MTN9706QTzafrir Sheffer · Seattle, WAN9706TStoddard Micah J · Boise, IDN9706VDagnon Paul A · Apple Valley, MNN9706XEl Paso Aero Inc · El Paso, TXN97071Heckathorn Chad W Trustee · Elk Point, SDN97073Rodland Karin D · New Concord, OHN97075Sopwith Camel Flying Club LLC · Salt Lake City, UTN97077Trail-Guides LLC · Sharpsburg, GAN9707GBurns Patrick · Carnation, WAN9707JTop Hand Inc · Laurel, MTN97082N97082 LLC · Scottsdale, AZN97084Dockall Jesse A · Litchfield Park, AZN97087Alpha Bravo LLC · Egan, LAN9708ABlack Mountains Air LLC · Madison, INN9708BBaxter Christopher V · Anchorage, AKN9708GDma Enterprises LLC · Fort Worth, TXN97096Lacy Clay · Groveland, CAN97097Youngman David A · Boca Raton, FLN97099Northwoods Air LLC · Orono, MEN9709AMckibbon Paul Lee · Millsap, TXN9709BPeterson Air LLC · Chisago City, MNN970MRGlobal Aviation LLC · Grain Valley, MON970RBBas Part Sales LLC · Greeley, CON970SETraining Planes LLC · Tampa, FLN970YGCbk LLC · Eagle, CON9710BWellnitz Patrick · Whitewater, WIN9710GThompson William G · Mattawa, WAN9710TTrzynka Dean A · Iron River, WIN97116N97116 LLC · Hector, MNN9711AJones Stanley A · Benkelman, NEN9711GBurcham Robert A · Anchorage, AKN9711ZRed Leasing LLC · Juneau, AKN97123Peak Investments LLC · Roanoke, VAN97127Sandquist Michael A · Molalla, ORN9712BLafleur Kerry P · Fort Worth, TXN9712GReynolds Frederick A · Pilot Point, AKN97133Niner 7133 LLC · Layton, UTN9713ARueckl Randall L · Hortonville, WIN9713GKochert Timothy B · Anchorage, AKN97146Silver City Aviation LLC · Sterling, KSN97148Cullen Kevin · Bethesda, MDN9714AReinoehl Gregg A · Reelsville, INN9714XEtheredge William T IV · Texas City, TXN97154Poddoubnyi Andrey Alexandrovich · Vista, CAN97156Skaglin Michael S · White Lake, MIN97157Oliver Blake H · Talbotton, GA
Back to AD 87-20-03 R2