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.
N780UOhio University · Albany, OHN780ZCornerstone Aviation LLC · Columbus, INN780ZAGreat Lakes Belle LLC · Furlong, PAN7810DPetro Jerry R · Williamsburg, VAN7810PCompass Aviation LLC · Lagrange, GAN78110Fries Tyler · Kenai, AKN78112Botnick Eric L · Luling, LAN7811DGardner Thomas R · Summerville, SCN7811PLitz Mark C · Mission Viejo, CAN7811SCrop Air LLC · Eaton, CON7811VRivard Jayme · Monterey, CAN78123Rrr3 LLC · Midway, FLN78124Barrow James L · Elizabethtown, KYN78126Orme Jason R · Red Oak, IAN7812MAerial Farmer LLC · Missoula, MTN7812NSwaz Aviation LLC · Mesa, AZN7812VStorrud Jerrel T · Corvallis, MTN7812WSidner Jeffrey Paul · Colorado Springs, CON78130Garoutte Kirk E · Anchorage, AKN78139Van Straten Patrick F · Shiocton, WIN7813DBurkhart Galen L · Portland, ORFirst renewal noticeN7813WMnt Aviation LLC · Fairmont, WVN78142Partyka Kenneth M · Circle Pines, MNN7814ASchmidt Philip E · Weatherford, OKN7814NBynum Robert Austin II · San Antonio, TXN7814VBewley Terry V · Longview, TXN78150Dreyer Elwain C · Cardington, OHN78158Hill Donald J · Godfrey, ILN7815FBrammer Bryon L · Simi Valley, CAN7815GNextgen Flight Academy Inc · Riverside, CAN7815NSmall World Aero Solutions LLC · Belton, TXN7815VApice James M · Port Orange, FLN7815YPinhoc Inc · Winter Garden, FLN7816NMagee Michael J · Olathe, KSN7816RRays Aircraft Sales LLC · Tolland, CTN7816VBrown Timmy L · Poplar Bluff, MON78174Spencer Aviation Inc · Delaware, OHN78179Horgan Robert V Jr · Wolfeboro, NHN7817DRike James O · Kittery Point, MEN7817GBarnhard James L · Washington, DCN7817PGoff Mark A · Grand Blanc, MIN7817VWilliams Donald B · Wingate, NCN78180Gatewood Doris E · Stokesdale, NCN78182Ajayi Samuel O · Jacksonville, ARN78183Smolik Vincent C · Ponder, TXN78186Johnson Gavin R · Othello, WAN78188Stein John R · Central Lake, MIN7818GLippert Charles Phillip · Southwick, MAN7818NFubar Flyers Inc · Port Charlotte, FLN7818PJohnson Herbert A · Evart, MI
Back to AD 87-10-06 R1