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.
N8070Farrington Andrew J · Shelton, WAN80700Changes In Latitude LLC · Kingwood, TXN80702Over The Numbers LLC · Churchville, PAN8070PDowns Steven M · Camden, TNN8070UMartin Jack W Jr · Dublin, GAN8070WMordini Robert D · Grand Marais, MNFirst renewal noticeN8071NFigone David Anthony · Williams, AZN8071PMatherley Frank · Greenbrier, TNN8071SNolan Cynthia M · Rimrock, AZN8071WFernandez Gregory · San Antonio, TXN8071XFlorida Aviation Career Training Inc · Saint Augustine, FLN8071YFrost Aviation Services Inc · Las Cruces, NMN8071ZScanlon Daniel T Jr · East Greenwich, RIN80725High Flight Academy LLC · Allison Park, PAN80729Poon Tsui P · Rosemead, CAN8072POn Three Angels Wings LLC · Melbourne, FLN8072TLane Aviation LLC · Tijeras, NMN8072XHillsboro Aero Academy LLC · Hillsboro, ORN8072YStoraker Kjetil · Mckinney, TXN80730Davis Lee B · North Little Rock, ARN80731Herman Robert W · Vineyard Haven, MAN80734Tipps Robert J Jr · Port Aransas, TXN80735S & S Aircraft Inc · El Dorado, ARN80738Woods Duane · Enid, OKN8073DPetersen Mark A · Willow, AKN8073EOcean Aviation Inc · Berlin, MDN8073NKiwi Choppers LLC · Hillsboro, ORN8074Turner Bryan J · Occidental, CAN80742Elliott Richard D · Castle Rock, WAN8074DVan Hatten Michael Sr · Fairbanks, AKN8074TWilliams Evan H · Sebastopol, CAN8074YWhistle Air LLC · Seymour, INN80751Haaland Karlyle R · Dalhart, TXN80756Badeaux William C Jr · La Porte, TXN80759Leaseair LLC · Wilmington, DEN8075CGuest Stephen J · El Cajon, CAN8075EBlue Sky Flying Club LLC · Granger, IAN8075JClark Nikita C · Ontario, ORN8075PAir Ads Inc · El Cajon, CAN8075WPale Horse Imports Inc · Shingletown, CAN8075XBruce Jerry W II · Starkville, MSN8075YAirplanes Of Kankakee · Kankakee, ILN80762Moving Tails Aviation LLC · Woodbridge, VAN80764Mcneill Jim R · Wichita, KSN80765Taylor Kyle T · Texas City, TXN80767Ainsworth Martha Trustee · Bowie, MDN80769Tucker Robert O · Savannah, GAN8076CStuart Chris W · Fairbanks, AKN8076PBrownie Dale R · Stetson, MEN8076WTipton James · Hot Springs, AR
Back to AD 87-10-06 R1