AD 87-20-03 R2
Registered aircraft · 54,015
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-20-03-R2')
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-20-03-R2')
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-20-03-R2') 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-20-03-R2') 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.
N94227Dodson International Parts Inc · Rantoul, KSN9422BFallbrook Air Service · Fallbrook, CAN9422HFort Smith Flying Club Inc · Fort Smith, ARN9422KFaulkner Harry E Jr · Bethel, AKN9422TGraves Frank C · Nocona, TXN9422UHortman Ryan Davis · Summerville, SCN9422XLittle Bird Airways LLC · Hamburg, NYN94237Brett Ryan J · Wasilla, AKN9423BDrean Alelandre C · Ajo, AZN9423MPaquette Ralph H Jr · Apalachin, NYN94244Bryant Kenneth D · Black Diamond, WAN94247Solberg Aviation Co Inc · Whitehouse Station, NJN9424EAero Equities LLC · Ventura, CAN9424TGill Melvin L Jr · Nashville, TNN9425BGloeckler Alex · Pearl City, ILN9425CInternational Air Services Inc Trustee · Carson City, NVN9425HWingsleasing LLC · Wichita, KSN9425TBlue Skies Flying Services LLC · Blandon, PAN9425XOatney Jared C · South Hutchinson, KSN94260Sutton Aircraft Salvage LLC · Palmer, AKN94263Hitch Aviation Inc · Malta, MTN94266Braun Kristy J · Fairbanks, AKN94267Hop Props LLC · Houston, TXN9426CBenson Fred B · Cle Elum, WAN9426EDarcy Aviation LLC · Danbury, CTN9426KO Max Aviation · Willowbrook, ILN9426XBradley Brunhilde K Trustee · Litchfield Park, AZN94270N94270 LLC · Chesterfield, NJN9427MWillthedrill LLC · Las Vegas, NVN94285Great Lakes Enterprises · Heron, MTN94286Purdue Aviation LLC · West Lafayette, INN9428CJones Kathleen W · Springfield, ORN9428GSecond Wind Aviation Corp · Friday Harbor, WAN94292My Way Aviation LLC · Weston, FLN9429CLanham Rex E Jr · Boise, IDN9429UTangleport LLC · Amarillo, TXN9429XWorld Missions Outreach · Brownsville, TXN942AZAz2025 LLC · Miami, FLN942JMPogany Steve C · Chugiak, AKN942SAWalker John A · Kotzebue, AKN942SMMackie Jonathan M · Manistique, MIN942XAClymer Jordan · Cape Canaveral, FLN94303Nelson Ryan L · League City, TXN94304Hamilton Francis D III · Olney, TXN9430BFuture Flyers Of Connecticut LLC · Simsbury, CTN9430CRoberts Creek Holdings LLC · Bakersfield, CAN9430MKruschwitz David A · Anchorage, AKN9430TRmb Leasing Inc · Dover, DEN9431MMeridian Airport Authority · Meridian, MSN9431XShives Investments LLC · Zavalla, TX
Back to AD 87-20-03 R2