Skip to content

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

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

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.

N60895Donald Williamson · Piedmont, SDBuilt 1969 · S/N 15070652 N60899Flight Services Inc · Headland, ALBuilt 1969 · S/N 15070654 N6089BValentine Terence S · Glennallen, AKBuilt 1957 · S/N 34089 N6089KDelta State University · Cleveland, MSBuilt 1980 · S/N 17274166 N6089MAirplanes And Helicopters Of Oregon LLC · Sisters, ORBuilt 1980 · S/N 15284617 N6089RLeadbetter Roy A · Georgetown, TXS/N 17253758 N608DLByler Jason M · Middlefield, OHS/N 17274998 N608EAKingsky Flight Academy LLC · Lakeland, FLBuilt 1978 · S/N 15282193 N608FDMjd Yuma Enterprises LLC · Yuma, AZBuilt 1981 · S/N 21064261 N608FGWilliam J Taylor Aviation LLC · Kendallville, INBuilt 1979 · S/N 18266913 N608FMSouth Bay International Flight Association Inc · Torrance, CABuilt 1978 · S/N 15282795 N608LDWeldon Robert S · Tallahassee, FLBuilt 1958 · S/N 50206 N609033bs Land Development LLC · Seattle, WABuilt 1969 · S/N 15070657 N6090ARegistered aircraftBuilt 1956 · S/N 28690 N6090RPaul Rowe Memorial Airport Association Inc · Kahoka, MOBuilt 1965 · S/N 17253759 N6090VRoberts Jon J · Parker, COBuilt 1980 · S/N 172RG0573 N60912Krogh Zachary H · Mc Laughlin, SDBuilt 1969 · S/N 15070663 N60916Webb Hunter · Altamont, UTBuilt 1969 · S/N 15070666 N60919Lassie Lite LLC · Rhinebeck, NYBuilt 1969 · S/N 15070669 N6091ABarrientos Jeri · Collinsville, OKS/N 28691 N6091BMcmurry Andrew Clinton · Sandy Hook, MSBuilt 1957 · S/N 34091 N6091DMentone Flying Club · Rochester, INBuilt 1979 · S/N 17272599 N6091GAkin Evrin · Newport Beach, CABuilt 1969 · S/N 15071591 N6091TDyck David C · Lake Forest Park, WABuilt 1964 · S/N 15060791 N6091VJames Jay C · Mesa, AZBuilt 1980 · S/N 172RG0574 N60926Watson Stephen A · Scottsdale, AZBuilt 1969 · S/N 15070673 N6092BKeenan Michael John Trustee · Anchorage, AKBuilt 1957 · S/N 34092 N6092FJasper Aviation Inc · Jasper, ALBuilt 1979 · S/N 17273146 N6092GComeau Charles · Brimfield, MABuilt 1969 · S/N 15071592 N6092MSchmucker Daniel · Bryn Athyn, PAS/N 15284619 N6092RBrock Roy C Jr · Pilot Point, TXBuilt 1965 · S/N 17253761 N6092TPurkinje Ltd LLC · Wilmington, DEBuilt 1964 · S/N 15060792 N6092VAir Venture LLC · Au Gres, MIBuilt 1980 · S/N 172RG0575 N60930Time Machine LLC · Kailua Kona, HIBuilt 1969 · S/N 15070674 N60938Thomas Michael F · Glennallen, AKS/N 15070679 N6093ARecker Nicholas P · Franklin, TNBuilt 1956 · S/N 28693 N6093FLrh Equipment LLC · Pendleton, ORBuilt 1975 · S/N 18264108 N6093GCaylin LLC · Wilmington, DEBuilt 1969 · S/N 15071593 N6093JAir S & T LLC · San Juan Capo, CAFirst renewal noticeBuilt 1980 · S/N 17273856 N60940O Lazy L Ranch & Farm · Satanta, KSBuilt 1969 · S/N 15070681 N60941Mayo Wilburt E Jr · Landers, CABuilt 1969 · S/N 15070682 N60943Walters William L · Boise, IDBuilt 1969 · S/N 15070684 N60944Brecht Deen R · Golden Valley, NDBuilt 1969 · S/N 15070685 N60945Gray Rick L · Eagle River, AKBuilt 1980 · S/N 18504081 N6094AKtkv Flyers Inc · Tomahawk, WIBuilt 1956 · S/N 28694 N6094BT 210 Telluride Corp · Aspen, COBuilt 1978 · S/N 21062681 N6094FBuiqui Aerospace Corp · Kissimmee, FLBuilt 1979 · S/N 17273147 N6094JHyten Mark B · Zionsville, INBuilt 1973 · S/N A1500394 N6094KPcs Aviation LLC · Louisa, VAFirst renewal noticeBuilt 1975 · S/N 15077522 N60950Sattizahn William M · Fredericksburg, PABuilt 1969 · S/N 15070690

Back to AD 87-20-03 R2