Skip to content

Registered aircraft · 1,458

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:96-24-17-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:96-24-17-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:96-24-17-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:96-24-17-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:96-24-17-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:96-24-17-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.

N71936Winell Carol D · Orange, CABuilt 1946 · S/N 3363 N71937Wheeler William N · Seattle, WAS/N 3364 N71941Mckinsey Thane R · Laramie, WYBuilt 1946 · S/N 3368 N71942Distant Horizons LLC · Irondale, ALBuilt 1946 · S/N 3369 N71945Stake Ken C · Visalia, CABuilt 1946 · S/N 3372 N71954Shattuck Charles W III · Goshen, CTBuilt 1946 · S/N 3381 N71955Wilson Earl · Rockford, ILBuilt 1946 · S/N 3382 N71960Registration Pending · Lampasas, TXRegistration pending, pending cancellationS/N 3387 N71962Aerotrack Inc · Hemet, CABuilt 1946 · S/N 3389 N71968Schrautemyer Albert Jr · Des Plaines, ILBuilt 1946 · S/N 3395 N71969Hagedorn Matthew J · Prineville, ORBuilt 1946 · S/N 3396 N71976Blessum Jay A · Minot, NDBuilt 1946 · S/N 3403 N71978Thompson Tommy Lee · Oakdale, CABuilt 1946 · S/N 3405 N71981Linville Raymond E · Carnesville, GABuilt 1946 · S/N 3408 N71986Green Dwayne · Santa Rosa, CABuilt 1946 · S/N 3413 N71988St Onge Robert J · Sterling, AKBuilt 1946 · S/N 3415 N71997Campbell Edward J · Chandler, OKBuilt 1946 · S/N 3424 N71998Sink Lendon V · Lexington, NCS/N 3425 N72000Muser Michael · Rockford, ILS/N 3427 N72005Kerr Jerry T · Mount Vernon, WABuilt 1946 · S/N 3432 N72009Bolton Derwin B · Jacksonville, TXBuilt 1946 · S/N 3436 N72011Boyce Michael C · Shelby, OHBuilt 1947 · S/N 5285 N72012Neeper James P · Fayetteville, NCBuilt 1946 · S/N 3439 N72022Sutton John S · Birmingham, ALBuilt 1946 · S/N 3449 N72029Nicols Bruce D · Titusville, PABuilt 1946 · S/N 3456 N72031Jaworski Roger W · Mesa, AZBuilt 1946 · S/N 3458 N72032Aero Missions Inc · Sylacauga, ALBuilt 1946 · S/N 3459 N72037Simmons Jason E · Austin, TXS/N 3464 N72043Econo Rate Rent A Car Inc · Windsor, COS/N 3470 N72051Deckard Steven W · Wellington, NVBuilt 1946 · S/N 3478 N72056Allen Thomas R · Kalispell, MTBuilt 1946 · S/N 3483 N72057Jackson Lee R · Baldwinsville, NYBuilt 1946 · S/N 3484 N72058Gorst Wayne R · Colville, WABuilt 1946 · S/N 3485 N72059Ramin Jeanette J · Houston, TXBuilt 1946 · S/N 3486 N72064Pyland Jack W · Seagoville, TXBuilt 1946 · S/N 3491 N72065Henderson James E · Greenville, TXS/N 3492 N72070Western Antique Aeroplane & Automobile Museum · Hood River, ORS/N 3497 N72071Marcoski Edward T · Downers Grove, ILBuilt 1946 · S/N 3498 N72072Tidball Paul Jon · Molalla, ORBuilt 1946 · S/N 3499 N72076Hughes Glenn D · Wrightsville Beach, NCBuilt 1946 · S/N 3503 N72080Eldred Thomas A · Jupiter, FLBuilt 1946 · S/N 3507 N72085Halpin John Hadden III Trustee · Sasakwa, OKBuilt 1946 · S/N 3512 N72087Letkeman John K · Seminole, TXBuilt 1946 · S/N 3514 N72090Davenport Ross K · Raleigh, NCS/N 3517 N72095Peterson Andrew B · Louisville, KYS/N 3522 N72097Sills Gary Michael · Waxahachie, TXBuilt 1946 · S/N 3524 N7220TVipond Andrew · Ormond Beach, FLBuilt 1949 · S/N 6439 N726HBDeatherage Tony · Goshen, OHS/N 4561 N73851Igoe James J Jr · Cincinnati, OHS/N 4293 N74334Schmiedt Daniel M · Westminster, SCBuilt 1946 · S/N 2761

Back to AD 96-24-17 R1