Skip to content

Registered aircraft · 8,139

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-10-01-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-10-01-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-10-01-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-10-01-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-10-01-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-10-01-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.

N4642RSkyways Group LLC · Greensboro, NCBuilt 1966 · S/N 28-21396 N4645RKunz Consulting Inc · Sun Prairie, WIBuilt 1966 · S/N 28-21399 N4646RWarren Global LLC · Chino, CABuilt 1966 · S/N 28-21400 N4649RHartley Zachary K · Dublin, GABuilt 1966 · S/N 28-21404 N4652RSpringfield Flying Club Inc · Ludlow, VTS/N 28-21407 N4653RElite Fleet Jacksonville LLC · Jacksonville, FLBuilt 1966 · S/N 28-21408 N4654RBas Part Sales LLC · Greeley, COBuilt 1966 · S/N 28-21409 N4655RFroeschl Christopher J · Roanoke, VABuilt 1966 · S/N 28-21410 N4656RSheremeta David T · Beverly Hills, FLBuilt 1968 · S/N 28-24834 N4658RRegistration Pending · Sand Springs, OKRegistration pendingBuilt 1966 · S/N 28-21413 N4659RSchmitt Michael T · Danville, ILBuilt 1966 · S/N 28-21414 N465CJAllegro Christopher J · Simi Valley, CABuilt 1967 · S/N 28-4465 N4660ROgren William E · Red Wing, MNBuilt 1966 · S/N 28-21415 N4661RSternberg Alexander J · Key Largo, FLBuilt 1966 · S/N 28-21416 N4663RLockwood Michael C · Edmond, OKBuilt 1966 · S/N 28-21418 N4664RRd Aire LLC · Opelika, ALBuilt 1966 · S/N 28-21420 N4665RGaulden Dennis N · Waukesha, WIBuilt 1966 · S/N 28-21421 N4667RAdams Michael S · Huntsville, ALBuilt 1966 · S/N 28-21423 N4669FHoese Clinton M · Spring Branch, TXS/N 28-7725026 N4671RRudder Burt H · Alamo, NVBuilt 1966 · S/N 28-21428 N4673RBall Dontel J · Tacoma, WABuilt 1966 · S/N 28-21430 N4675RLatham Cary · Hardin, KYBuilt 1966 · S/N 28-21432 N4677RFields Michael L · Rockwood, TNS/N 28-21434 N4678RRegistration Pending · Vadnais Heights, MNRegistration pendingS/N 28-21436 N4680RGibbs Robert I · Ravenswood, WVBuilt 1966 · S/N 28-21439 N4682RTremblay Stanley R Sr · Dexter, MEBuilt 1966 · S/N 28-21441 N4683TBatchelor William · Sicklerville, NJBuilt 1972 · S/N 28-7225199 N4687RMontz Steven Andrew · Mandeville, LABuilt 1966 · S/N 28-21448 N4688RGerdes T Michael · Brownsburg, INBuilt 1966 · S/N 28-21449 N4689RRegistered aircraftAssigned, pending cancellationS/N 28-21450 N4690RCannon Kyle J · Salt Lake City, UTBuilt 1966 · S/N 28-21452 N4691RBest Equipment Leasing LLC · Bakersfield, CABuilt 1966 · S/N 28-21453 N4692RKaresh Eli · Orlando, FLBuilt 1966 · S/N 28-21454 N4694RKent Adam · Rogersville, MOBuilt 1966 · S/N 28-21457 N4695RDestination Flyer LLC · Memphis, TNBuilt 1966 · S/N 28-21459 N4696RSchroter Jon A · La Crosse, KSBuilt 1966 · S/N 28-21460 N4697RHolthaus Cody · Eden Prairie, MNBuilt 1966 · S/N 28-21461 N4699RGillis Jeremiah · Cody, WYBuilt 1966 · S/N 28-21463 N46APMorris Christopher J · Crockett, TXBuilt 1963 · S/N 28-1203 N4701LTrainor Jonathan P · Bridgewater, NJS/N 28-4014 N4703LMaust Luke A · Accident, MDBuilt 1967 · S/N 28-4017 N4705LHorton Kelly · Hollis, OKBuilt 1967 · S/N 28-4019 N4706LKings Heir Inc · Kent, WABuilt 1967 · S/N 28-4026 N4708LAlexander Nicholas R · Oak Hill, OHBuilt 1967 · S/N 28-4027 N4709LJohannsen Michael R · Allen, TXBuilt 1967 · S/N 28-4028 N470FLBaker Brian K · Dayton, OHBuilt 1971 · S/N 28-7125271 N4710LStuhmer Samuel K · Central City, NEBuilt 1967 · S/N 28-4029 N4713CTron Aviation LLC · Orlando, FLS/N 28-7225574 N4713LHutson Richard M · Trenton, SCBuilt 1967 · S/N 28-4032 N4715LSmith Bryan E · Mt Juliet, TNBuilt 1967 · S/N 28-4035

Back to AD 96-10-01 R1