Skip to content

Registered aircraft · 54,017

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.

N3290FCline Mark A · Winston Salem, NCBuilt 1967 · S/N R172-0222 N3290JFitzgerald Jacob J · Pullman, WABuilt 1966 · S/N 15065990 N3291EKukuchka Ronald G · Tunkhannock, PABuilt 1978 · S/N 17271493 N3291LSun Baron · Arcadia, CABuilt 1967 · S/N 17256191 N3291SRegistration Pending · Highland, ILRegistration pendingBuilt 1964 · S/N 18255791 N3291ZMiller Andy D · Marana, AZBuilt 1973 · S/N 15075105 N3292TCelestial Kinetics Flight Academy LLC · Waupaca, WIBuilt 1967 · S/N 17700592 N3292UAnnecchini Frank C Jr · Overland Park, KSBuilt 1963 · S/N 18254692 N3293DGuilliams Carl · Gilbert, AZBuilt 1955 · S/N 32091 N3293YKiedinger John D · Burleson, TXS/N 18254293 N3294TWolniansky Peter W · Ocean Grove, NJS/N 17700594 N3294UWidener Christine A · Tucson, AZBuilt 1963 · S/N 18254694 N3295JClonts Kim E · Knox City, TXS/N 15065995 N3295YReid Brian M · Boise, IDS/N 18254295 N3296SBeekman Steven J · Stephenson, MIBuilt 1964 · S/N 18255796 N3296UBierer David E · Victor, MTBuilt 1963 · S/N 18254696 N3296YBeckord Aaron P · Tacoma, WABuilt 1962 · S/N 18254296 N3297LRaymond Patrick H · Jerseyville, ILBuilt 1967 · S/N 17256197 N3297TBurgdorf Dale A · Plano, TXBuilt 1967 · S/N 17700597 N3297YMust Dash Rides Flying Club LLC · Raleigh, NCBuilt 1962 · S/N 18254297 N3298LThompson Edward E · Buxton, MEBuilt 1967 · S/N 17256198 N3298SHolloway Cody L · Belle Plaine, KSBuilt 1964 · S/N 18255798 N3298T515 Aviation LLC · Dexter, IABuilt 1967 · S/N 17700598 N3299EBeglin Bruce W · Oxford, MDBuilt 1978 · S/N 17271495 N3299JEdwards Wallace · Commerce, MIS/N 15065999 N3299LHarrington David J · Albuquerque, NMBuilt 1967 · S/N 17256199 N3299SS V Aeronautics LLC · Afton, WYBuilt 1964 · S/N 18255799 N3299TSale Reported · Daytona Beach, FLSale reported, canceledBuilt 1967 · S/N 17700599 N3299URichardson Ronnie L Jr · East Wenatchee, WAFirst renewal noticeBuilt 1963 · S/N 18254699 N3299VChannel City Flyers Inc · Goleta, CABuilt 1974 · S/N 15076452 N329DJBritt Matthew W · Trenton, SCBuilt 1976 · S/N 177RG0845 N329JFJ F Aviation Inc · Joliet, ILBuilt 1975 · S/N 17265835 N32AKHummel Karl · Brooklyn, NYBuilt 1973 · S/N 18261935 N32BEWisecup Wilbur V Jr · Germantown, OHBuilt 1974 · S/N 17263249 N32CHHeckler Gary C · Carefree, AZBuilt 1966 · S/N 18257332 N32CWMcdiarmid Jeffrey · Walla Walla, WABuilt 1977 · S/N 18265680 N32DBCarpenter Forrest A · Berthoud, COBuilt 1966 · S/N 18051714 N32EKTips Dan N · Plano, TXBuilt 1963 · S/N 18051264 N32FCZimin Transportation LLC · South Naknek, AKBuilt 1953 · S/N 30431 N32GVEastern Cincinnati Aviation Inc · Batavia, OHS/N 17267026 N32LACircle S Aviation LLC · Starkville, MSBuilt 1972 · S/N 17260454 N32MCCook Tracy L · Prosper, TXBuilt 1974 · S/N 21060482 N32MPAshford Aviation Inc · Dothan, ALBuilt 1981 · S/N 172RG1019 N32PLDiette Paul S · Middlebury, VTBuilt 1980 · S/N 18267595 N32PXKustatan Leasing LLC · Kenai, AKBuilt 1976 · S/N U20603343 N32RLVb Glass Company Inc · Jamestown, CAS/N U20605551 N32TCarolina Blue Aviation LLC · Villanova, PABuilt 1978 · S/N 18266670 N32VACommonwealth Of Virginia · Richmond, VABuilt 1974 · S/N 182-63322 N32YAFlydreams Aircraft Group Inc · Fort Lauderdale, FLBuilt 1980 · S/N 17273862 N32ZZJp Lemke Aviation LLC · Jenison, MIBuilt 1977 · S/N 18265469

Back to AD 87-20-03 R2