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.
N8403VDonica L H · Marana, AZN8403YBlair Robert A · Red Bluff, CAN84048Kyzer Aviation Holdings LLC · Fort Mill, SCN8404CLudwick Paul W · Lighthouse Point, FLN8404PRegistration Pending · Pittsburgh, PARegistration pending, pending cancellationN84050Alpenglow Air 2 LLC · Anchorage, AKN84054Far Horizons LLC · Ravenel, SCN8405BMiloud Chadd K · Fort Worth, TXN8405PCarlin Chad P · San Juan Capistron, CAN8405RShields Parker · Port Orange, FLN8405SAlston Tony · Midland, TXN8405WTaylor Dale E · Kimball, SDN8405YBjorkman Marvin S · Richardson, TXN8406244 Flyers · Harlowton, MTN84063Rothermel Donald M · Mokena, ILN8406AColorado High Flyers LLC · Colorado Springs, CON8406HP A Flying LLC · Pueblo, COFirst renewal noticeN8406LVee Neal Aviation · Latrobe, PAN8406WWright Jordan M · York, SCN8406YPilgrim Robert C · Cape Coral, FLN84071Roadrunner Flight School LLC · Farmington, NMN84072Ferre Taylor · Kirkland, WAN84076Third Step 3 LLC · Gilbert, AZN8407DRegistration Pending · Manassa, CORegistration pendingN8407LPlainwell Aviation And Stem Academy · Kalamazoo, MIN8407MJohnson Michele J · Buena Vista, CON8407PMark Gary Flying Service Inc · Inverness, MSN8407VDonica Leldon H · Marana, AZN8407WIsland Flyers LLC · Apopka, FLN8407YAwad Aviation LLC · Pooler, GAN84082Weinheimer Paul T · Amarillo, TXN84086Smoky Mountain Flyers · Murphy, NCN8408BCharlton Gary R II · Loudonville, NYN8408CDallas Secure Storage LLC · Dallas, ORN8408DAeromarine Consulting Inc · Brandon, FLN8408ECandace A Larned Enterprises Inc · Long Beach, CAN8408LMacair Aviation LLC · Xenia, OHN8408PBeavers Jeffrey · Metairie, LAN8408RWilliams Christopher A · Kent, WAN8408TBrocas LLC · Marlborough, NHN84092Brown Stephen J · Chandler, AZN84093Hruska Coyle J · Lime Springs, IAN84097Argoudelis Michael · Kalamazoo, MIN8409AWngz Aviation Apparel LLC · Sanford, FLN8409DWinters David W · Gustine, TXN8409HAerocolibri LLC · Nampa, IDN8409LRegistered aircraftN8409PStevenson Gregory J · Sutter Creek, CAN8409RRatliff Christopher · Manteno, ILN8409YRivera William Carl · Silver Spring, MD
Back to AD 87-10-06 R1