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.
N6940NPelissier Joseph E Trustee · Cary, NCN6940UNewby Adam M · Anchor Point, AKN69419Ninke Justin E · Fond Du Lac, WIN6941DKodysh Peter J · North Ridgeville, OHN6941JPalmenteri Louis J · Rhome, TXN6941NCaro Carlos H · Mcallen, TXN6941UBukac Glenn P · Villa Park, ILN6942Schwartz Kenneth G · Lincoln, CAN6942JAndromeda Air LLC · Houston, TXN6942KGold Cap LLC · Bremerton, WAN6942WBobbe Debra M · Paradise Valley, AZN6942YVan Fossen Eddie L · Bakersfield, CAN6943AOber John A · Candor, NYN6943BAndrews Joshua T · Lakeview, ORN6943NPhoenix Aviation Holdings LLC · Mesa, AZN6943YAce Tomato Co LLC · Daytona Beach, FLN6944APacific Fleet Aviation LLC · Rochester, NYN6944CUpdraft Leasing LLC · Tea, SDN6944EHinds Archie L · Claremore, OKN6944JJhap LLC · Hubbard, OHN6944NYates Gary Douglas · Rose Hill, KSN6944WWerner Robert T · Blue Grass, IAN6944YLg Aztec LLC · Boynton Beach, FLN6945JK&B Properties LLC · Lexington, SCN6945NEveland Benjamin E · Henderson, NVN6945PBerg Alvin L · Overgaard, AZN6945QEllis Jordan Barrett · Oklahoma City, OKN6945UGipe Douglas A · Malvern, IAN6946CRegistration Pending · Fairbanks, AKRegistration pending, canceledN6946QBlalock James M · Sheridan, ARN6947BB&R Aerial Crop Care Inc · Connell, WAN6947NFlyfaraway Partners LLC · Sparta, NJN6947PHudzinski Joel David · Newaygo, MIN6947VGutierrez Juan · Sarasota, FLN6948NPeck Jeff · Denton, TXN6948PBernard David J · Paris, OHN6948WCraig Joshua G · Bonaire, GAN6949BPool Gene E · Anchorage, AKN6949NBanos Peter T · Coalinga, CAN6949PDepew Kevin I · Everett, WAN6949ULambert Donald H · Westwood, MAN6949VPaul Kevin A · Belgrade, MTN6949WSa Fliers LLC · Venice, FLN6949ZTide Water Soaring Society Inc · Windsor, VAN694ABGoldpick Dirtworx LLC · Wasilla, AKN694APCook Christopher W · Indian Mound, TNN694ARWilliams Robert R · Vernonia, ORN694BASlawko Paul A · Elverson, PAN694BKBell Bruce · Desert Aire, WAN694BWOtter Creek Aviation LLC · Columbus, GA
Back to AD 87-10-06 R1