Skip to content

Registered aircraft · 10,639

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:99-01-05-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:99-01-05-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:99-01-05-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:99-01-05-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:99-01-05-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:99-01-05-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.

N31025Lupei Donald E Trustee · Yorkville, ILBuilt 1940 · S/N 5-301 N31028R H K Of Kansas Inc · Overland Park, KSBuilt 1940 · S/N 5266 N3102MCaldwell Bryan S · Litchfield Park, AZBuilt 1947 · S/N 12-1789 N31038Neely Brody R · Fairbanks, AKBuilt 1940 · S/N 5-304 N3103MTygart Michael J · Olive Branch, MSBuilt 1947 · S/N 12-1793 N31047Voorheis Donald R · Hemlock, MIBuilt 1940 · S/N 5275 N31057Rendel James L · Rock Hill, SCS/N 5-306 N31065Rasmussen William J III · Mattoon, ILS/N 5305 N31071Wilkins Raymond E · Osceola, IABuilt 1940 · S/N 5-305 N3107ZBauer Dereck R · Springfield, ORBuilt 1959 · S/N 22-7041 N31085Bandit Air LLC · Stowe, PAS/N 5311 N31086Cabigas John V · Yuba City, CABuilt 1940 · S/N 5314 N31089Forss Jamey L · Ferndale, WABuilt 1940 · S/N 5315 N3108MGlover Thomas B · Marana, AZS/N 12-1796 N3108ZRinehart John M · Shelbyville, INBuilt 1959 · S/N 22-7047 N31091Lomeli Angelo · Spring, TXS/N 5374 N3109ZMayer Michael · Milford, UTS/N 22-7048 N310TManiatis Michael · Milton, NYS/N 18-2424 N3110ZLombardo Robert C · Clarks Summit, PABuilt 1959 · S/N 22-7049 N31118Smith Walter E Jr · Villa Ric A, GABuilt 1940 · S/N 5336 N3111MGritzo Russell · Edgewood, NMBuilt 1947 · S/N 12-1799 N31125I Fly Enterprise · Lexington, NCBuilt 1940 · S/N 5315 N3112ZSchifano Benedict S · Scottsville, NYS/N 22-7051 N3114FByrd Ronald R · Polk City, FLS/N 22-8615 N3114MFarber Adam J · Odessa, TXS/N 12-1807 N31165Hackenburg Jess P · Montoursville, PAS/N 5322 N3117ZYoung Donald L · Anniston, ALS/N 22-7062 N3118ZTridogs LLC · Cleveland, GABuilt 1959 · S/N 22-7063 N31193Birkhold Craig A · Napoleon, OHBuilt 1940 · S/N 4-1279 N31194Tigert Tommy R · Ovilla, TXBuilt 1940 · S/N 4-1280 N31196Royal Deanna J · Duluth, MNBuilt 1940 · S/N 4-1288 N3119ZStoner Paul V · Austin, TXBuilt 1959 · S/N 22-7064 N311ELashuay Donald I · Midland, MIBuilt 1946 · S/N 12-411 N311KKeeler Allan A · Woodbury, CTBuilt 1954 · S/N 18-3597 N311QGrant Roderick M · Dillingham, AKBuilt 1957 · S/N 18-5697 N311TLark Aircraft Leasing · Port Townsend, WABuilt 1953 · S/N 18-2425 N3120ZGifford Thomas Lloyd · Canadian, TXS/N 22-7065 N3121BOxley Kevin L · Huntington, INS/N 5-314 N3123MLeroy Raymond S · Anchorage, AKBuilt 1947 · S/N 12-1823 N3123ZTripp Robert L · Walsenburg, COBuilt 1959 · S/N 22-7068 N3125MSale Reported · Elizabeth, COSale reported, pending cancellationS/N 12-1825 N3125ZFabris Thomas H · Reva, SDBuilt 1959 · S/N 22-7070 N3127ZLott William F Jr Trustee · Oklahoma City, OKS/N 22-7072 N31289Hall M Richard · Aliquippa, PAS/N 5-1478 N3128XWeiss Elliot · Fresno, TXS/N 18-2955 N3128ZGrady Robert DBA · Lansing, ILS/N 22-7073 N3129MHaggstrom Daryl V · Fairbanks, AKBuilt 1947 · S/N 12-1819 N3129ZCaldwell Caleb Z · Anchorage, AKBuilt 1959 · S/N 22-7074 N312MMBadgley Robert W · Stanley, NDBuilt 1976 · S/N 25-7656085 N312TMoore Joseph A · Kingwood, WVBuilt 1953 · S/N 18-2426

Back to AD 99-01-05 R1