Skip to content

Registered aircraft · 54,019

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.

N3068SZephyrhills Flying Club Inc · Tampa, FLBuilt 1967 · S/N 15066968 N3068UArlins Aircraft Service Inc · Belgrade, MTBuilt 1963 · S/N 17250668 N30691Hayden Boyce · Grand Rapids, MIBuilt 1969 · S/N 17701407 N30695Beck Paul D · Russell, IAS/N 17701409 N3069BRampersad Carlyle · Wilmington, DEBuilt 1952 · S/N 7953 N3069FBlaine Barry A · Campbell, CABuilt 1966 · S/N 18257169 N3069JSkymax Holdings LLC · Spokane, WABuilt 1965 · S/N 15061169 N3069QMarin Alberto · Mc Neal, AZS/N 18258069 N306DMWylie Aviation LLC · North Little Rock, ARBuilt 1974 · S/N 18262544 N306GWCollege Of Missionary Aviation Inc · Keystone Heights, FLS/N 17250714 N306TCN306tc LLC · Greenwich, CTBuilt 1976 · S/N 18503061 N30708Johnson Raymond W · Buffalo, MNBuilt 1969 · S/N 17701414 N30709Wessels Jr Steven A · Milledgeville, GABuilt 1969 · S/N 17701415 N3070AMacvey Troy R · Oxford, OHBuilt 1953 · S/N 25714 N3070BBriscoe Joseph C · Gresham, ORBuilt 1952 · S/N 7954 N3070JCascade Soaring Society · East Wenatchee, WABuilt 1965 · S/N 15061170 N3070YPearce Andrew R · Raleigh, NCBuilt 1962 · S/N 18254070 N30713Wallace James Ray · Baltimore, MDBuilt 1970 · S/N 17701417 N30717Day David G · Glendora, CAS/N 17701420 N30718Olson Andrew S · Copper Canyon, TXBuilt 1969 · S/N 17701421 N3071BSwing Shift Aviation LLC · Wilmington, DEBuilt 1952 · S/N 7955 N3071FRees Ryan G · Loa, UTS/N 18257171 N3071JHaas James D · Frisco, TXBuilt 1965 · S/N 15061171 N3071QNichols Waylon · Copeland, KSBuilt 1967 · S/N 18258071 N3071URegistration Pending · Sheridan, WYRegistration pendingBuilt 1963 · S/N 17250671 N3071XSmith Lawrence A · Alleyton, TXBuilt 1966 · S/N 15064471 N30727Blanchard Ken E · Lumberton, MSBuilt 1969 · S/N 17701426 N30728Lambert Hubert D · Lincolnton, NCBuilt 1969 · S/N 17701427 N30729Thompson William C III · Lawrenceville, ILBuilt 1969 · S/N 17701428 N3072AKinter Christopher A · Kodiak, AKBuilt 1953 · S/N 25716 N3072EReed Michael A Trustee · Minerva, OHBuilt 1978 · S/N 17271428 N3072JNavanugraha Piya · Hemet, CABuilt 1965 · S/N 15061172 N3072SRawson Aviation LLC · Pryor, OKBuilt 1967 · S/N 15066972 N3072VFlight Time Builders Inc · Memphis, TNBuilt 1974 · S/N 15076377 N30730Cassill Aircraft Leasing Inc · Cedar Rapids, IABuilt 1969 · S/N 17701429 N30734Paradise Mark F · Indianapolis, INBuilt 1969 · S/N 17701433 N3073AHarder William J · Anchorage, AKBuilt 1953 · S/N 25717 N3073FLuther Arnold D · Las Vegas, NVBuilt 1966 · S/N 18257173 N3073JFilter Keith F Jr · Lake Havasu City, AZBuilt 1965 · S/N 15061173 N3073SCresswell Aubrie J · Norwood, PABuilt 1967 · S/N 15066973 N3073YWf Aviation LLC · Bozeman, MTBuilt 1962 · S/N 18254073 N30741Nagy Mark M · Shingle Springs, CABuilt 1969 · S/N 17701435 N30743Bas Part Sales LLC · Greeley, COBuilt 1969 · S/N 17701437 N30747Silverwings Aviation LLC · Dover, DEBuilt 1969 · S/N 17701440 N3074BBohl Howard M · Temecula, CABuilt 1952 · S/N 7958 N3074JMehling Robert C · Hardin, MTS/N T18803600T N3074QGriffin John O · Driggs, IDBuilt 1967 · S/N 18258074 N3074STail Aero Corp · Wilmington, DEBuilt 1967 · S/N 15066974 N3074YIronman Welding Inc · Rifle, COBuilt 1962 · S/N 18254074 N30753Episcopal Wings Ministry Inc · Fairbanks, AKBuilt 1969 · S/N 17701443

Back to AD 87-20-03 R2