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.
N8651PGottschall Kenneth Lee III · Santa Paula, CAN8652NDavis Rick J · Los Lunas, NMN8652WCass Michael Norman · Moscow, IDN8653Rempel Warren K · Longmont, CON8653VLarson Paul E · Palmer, AKN8653WZook James E · Holt, MIN8653YMorris Equipment LLC · Yuma, AZN8654PRoman Louis · Bridgeport, CTN8654WJordan Kenneth J · The Villages, FLN8655PBrewster Michael L · Nipomo, CAN8655WGtj LLC · Johnston, IAN8656GRut-Roh Flyers LLC · Greer, SCN8656LAdirondack Soaring Association Inc · Ballston Spa, NYN8656NN8656n LLC · Weston, NEN8656PMcdonald Gregory S · Mena, ARN86571Houck Steven E · Fairbanks, AKFirst renewal noticeN86573Phoenix Aviation Services Inc · Miami, FLN86574Kern Hunter S · Anchorage, AKN86576Pirkle Anthony E · Theodore, ALN86578Halpin Aviation · Eden Prairie, MNN86579Youngs William D Jr · Moravia, NYN8657DParks John T · Ripon, WIN8657PSchoolcraft Carl L · West Harrison, INN8657VFrahm Michael T · Willow, AKN86582Sale Reported · Oxford, IASale reportedN86585Birchler Judy A · Indianapolis, INN86588Roberts Todd L · Friday Harbor, WAN8658LMid Atlantic Soaring Association Inc · Frederick, MDN8658NOne Way Aviation LLC · Warner Robins, GAN8658PPannell Butch W · Spring Branch, TXN86595Coker Janie K · Tyler, TXN8659CBraddock Randall C · Syracuse, KSN8659EKuehn Ricky A · Mesa, AZN8659PFiebig Howard James · Sebewaing, MIN8659WFlint Christopher · Tucson, AZN865AFLufthansa Aviation Training USA Inc · Goodyear, AZN865CPAmr Holdings LLC · Kalispell, MTN865CWSouthern Aviation · Anchorage, AKFirst renewal noticeN865DMMacniven Donald B · Colorado Springs, CON865ESHangar Ak LLC · Sterling, AKN865GAtp Aircraft 9 LLC · Wilmington, DEN865HBCharlie Alpha Bravo LLC · Spring Hill, KSN865KKDewalt Rodney P · Fort Worth, TXN865LJones Donald · Knoxville, TNN865PBAnthelian Helcopters · Long Beach, CAN865PUTrustees Of Purdue University · West Lafayette, INN865VLSale Reported · San Juan, PRSale reportedN865WAYjb Operations LLC · Altoona, PAN86605Gibbons Warren · Toledo, OHN86607Yellow Decathlon LLC · Algonquin, IL
Back to AD 87-10-06 R1