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.
N7224DBank Jeffrey J · Littleton, CON7224FBiviano Joseph J · Tehachapi, CAN7224MAffordable Construction Services Inc · Humboldt, TNN7224SCunningham Russell A · Zimmerman, MNN7224YDistel Harold M · Williamson, GAN7225GVance Wilbur H III · Hershey, PAN7225PSuperior Aviation LLC · Metairie, LAN7225VConnecticut Aircraft Sales LLC · Manchester, CTN7225WOshaughnessy Breandan · Allen, TXN7225YTwin Cam Holdings LLC · Union City, TNN7226DAdams Andrew V · Joplin, MON7226GHerlihy Douglas K II · Denville, NJN7226JChristffersen Robert H · Tacoma, WAN7226WStuart Ryan C · Snowflake, AZN7226YGilbert Douglas A · Weston, FLN7227DRobinson Eric C · Palmer, AKN7227FStrange Keith · Lincoln, MEN7227GBeltz Richard D · Lehighton, PAN7227JRad Aviation LLC · Abbeville, ALN7227QElite Air LLC · Tullahoma, TNN7227YClearview Aerial Solutions LLC · Rogersville, TNN7228DAmigo Helicopter Services LLC · Falfurrias, TXN7228GFasking Dan · Stanford, ILN7228JRedhanded LLC · Dover, DEN7228ZHart Samuel C Jr · Newberry, SCN7229DBuergel Sandra J · East Aurora, NYN7229JLivingston Corey · Myrtle Beach, SCN7229NMccracken Donald D · Keyport, WAN7229QSwitzer Frank Jr · Port Allegany, PAN7229VRiggin Flight Service Inc · Madison, SDN7229WRoll The Bones LLC · Kiln, MSN722AARobinson Charles F Jr · Portage, MIN722AKInternational Air Services Inc Trustee · Carson City, NVN722AVMcdaniel Ibarra Professional Services Inc · Palm Desert, CAN722BMButler Francis J · Fargo, NDN722CPFalcon 118 Denver LLC · Tiburon, CAN722CSBoccaccio Peter Anthony · Burke, SDN722CZThree D Adventures LLC · Newfolden, MNN722DBColaur LLC · Nashotah, WIFirst renewal noticeN722DCHiemstra Andrew Ralph Walter · Tuolumne, CAN722DMU S Wire Manufacturers Inc · Redwood City, CAN722ETSymonds Stephen M · Colleyville, TXN722FLShaughnessy Thomas E · Seabrook, NHN722GTable For Seven Aviation LLC · Mountain Brk, ALN722GACougar Ga-7 LLC · Helena, MTN722HAPerformance Sanitation Of Mississip · Deland, FLN722JWMcintosh Kenneth V · Pleasant Plain, OHN722KJCraddock Kevin D · Clemson, SCN722KWBaker Scott · Chesterton, INN722LWWineberg Lindsay · Beverly Hills, CA
Back to AD 87-10-06 R1