Skip to content

Registered aircraft · 25,370

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:80-25-07-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:80-25-07-R1') 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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N305PTCappe Investment Group LLC · Homestead, FLBuilt 1974 · S/N 17264131 N305XXDs Group LLC · Miami, FLBuilt 1975 · S/N 17265513 N30603Registered aircraftBuilt 1969 · S/N 17701353 N30612Wheeler Vincent · Harwinton, CTBuilt 1969 · S/N 17701360 N30615Yanichko Robert · Weeki Wachee, FLBuilt 1969 · S/N 17701362 N30617Executive Flight Training & Services LLC · Sanford, NCBuilt 1974 · S/N 17264149 N30626Hoese Ray D · San Antonio, TXBuilt 1969 · S/N 17701368 N30630Erickson Keith E · Anchorage, AKS/N 17701369 N30632Evv Pilots Club Inc · Evansville, INFirst renewal noticeBuilt 1969 · S/N 17701371 N30634Beck Alan · Las Vegas, NVBuilt 1969 · S/N 17701372 N30636Schub William C · Oakdale, NYBuilt 1969 · S/N 17701373 N30637Diamond Paul · Londonderry, NHBuilt 1969 · S/N 17701374 N30639Madden Michael A Trustee · De Pere, WIBuilt 1969 · S/N 17701375 N30643Hurst Gordon · Waterford, PABuilt 1974 · S/N 17264150 N30654Eagle Sky Patrol Inc · Deadwood, SDBuilt 1969 · S/N 17701386 N30656Vance Matthew Austin · Decatur, GABuilt 1969 · S/N 17701387 N3065E3065e LLC · Westfield, PABuilt 1978 · S/N 17271425 N30661Feiler Joe · Casper, WYBuilt 1969 · S/N 17701389 N30663Kroeker Bryan S · Grant, NEBuilt 1969 · S/N 17701391 N30668Elevation Aviation LLC · Mccomb, MSBuilt 1969 · S/N 17701394 N30670Brown Thomas E · Trenton, GABuilt 1969 · S/N 17701395 N30671Foster Milton F · Dawson, GABuilt 1969 · S/N 17701396 N30673Cardinal Flyers Inc · Sault Sainte Marie, MIBuilt 1969 · S/N 17701397 N30680Smith Ronald D · Anderson, INBuilt 1969 · S/N 17701401 N30685Blanchette George · Longwood, FLBuilt 1969 · S/N 17701404 N30686Tullos Morgan P · Austin, TXBuilt 1969 · S/N 17701405 N30691Hayden Boyce · Grand Rapids, MIBuilt 1969 · S/N 17701407 N30695Beck Paul D · Russell, IAS/N 17701409 N306ACHough Robert M · Windham, NHBuilt 2001 · S/N 1306-2000 N30708Johnson Raymond W · Buffalo, MNBuilt 1969 · S/N 17701414 N30709Wessels Jr Steven A · Milledgeville, GABuilt 1969 · S/N 17701415 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 N3071GWetherbee Steven R · Pollock, SDBuilt 1967 · S/N 98 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 N3072EReed Michael A Trustee · Minerva, OHBuilt 1978 · S/N 17271428 N30730Cassill Aircraft Leasing Inc · Cedar Rapids, IABuilt 1969 · S/N 17701429 N30734Paradise Mark F · Indianapolis, INBuilt 1969 · S/N 17701433 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 N3074GOver The Top Aviation Inc · Jonesboro, ARBuilt 1968 · S/N 466 N3074JMehling Robert C · Hardin, MTS/N T18803600T N30753Episcopal Wings Ministry Inc · Fairbanks, AKBuilt 1969 · S/N 17701443 N30754Johnson Jiju · Fox Point, WIBuilt 1969 · S/N 17701444 N3075YAir Eagle LLC · Rome, GABuilt 1979 · S/N 21063169 N30761Feaster Christopher D · Richmond, INS/N 17701448

Back to AD 80-25-07 R1