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.
N6965DFondy Victor L · Whitewood, SDN6965JDanik LLC · Harper Woods, MIN6965PBoucher Bobbi · Fredericksburg, VAN6965WSitaras Evangelos · Ladonia, TXN6966CSchlichter Timothy J · Huntsville, ALN6966JTwo Mile Final LLC · Spring, TXN6966RHill Aviation LLC · Starkville, MSN6966UUnderhill Robert A · Redding, CAN6966VBullard Joseph · Saint Louis, MON6966WYoumans Elbert Mitchell · Waynesboro, GAN6967CUp And Down Aviation LLC · Perry, GAN6967RGunnarsson Jon · Concrete, WAN6967UEstey Richard H · Thomson, GAN6967VMile High Air LLC · Holland, MIN6967WBengis Adam · Seattle, WAN6968PFoos LLC · Vancouver, WAN6968UFowler Craig A · Chireno, TXN6968VArnold Norman K · Fayetteville, ARN6968WMidgard Aviation LLC · Colton, SDN6969BBrown Dennis K · Reno, NVN6969HGittlein Matthew P · Wasilla, AKN6969PHart Richard W · Alexandria, VAN6969UBurdak Erik · Mound, MNN6969VArcher II Management LLC · Hernando, MSN696APiper Archer Three LLC · Wilmington, DEN696AGWings Over Texas Holdings LLC · Denton, TXN696AKSloans Aircraft Welding LLC · Anchorage, AKN696ARDreamcatcher Aero LLC · Austin, TXN696DBRobinson Michael C · Lakeland, FLN696DGFonseca Joseph K · Northlake, TXN696DWDelta Whiskey LLC · Huron, SDN696DYInline Developers LLC · Wilmington, DEN696EAHubbard Broadcasting Inc · Saint Paul, MNN696FGPro LLC · Gassaway, WVN696FLGood Joseph A · Weymouth, MAN696HDDylag Andrew J · Cold Spring, NYN696HJCold Rain Inc · Carleton, NEN696JANational Industrial Services LLC · Kingshill, VIN696LBN&C Aviation LLC · Niles, MIN696LHFf22 LLC · Scottsdale, AZN696MLAdventuresplash LLC · Ponte Vedra Beach, FLN696NGiles Forrest D · Springtown, TXN696PGreer James E Jr · Summit Point, WVN696RCastro Wladimir · Carolina, PRN696RJWeitman Jim Trustee · Decatur Island, WAFirst renewal noticeN696RKClassic Aviation Inc · Pella, IAN696SAThree Green Aviators LLC · Midland, TXN696SHGurry Deirdre M · Pt Pleasant, NJN696SPMj Paws LLC · Wilmington, DEN696WWinnick Richard E · Denver, CO
Back to AD 87-10-06 R1