Skip to content

Registered aircraft · 8,138

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.

N3712RMcbride Charles E · Omaha, NEBuilt 1970 · S/N 28-5798 N3713K3713 Kilo LLC · Athens, GAS/N 28-23702 N3716RDavey Richard T II · Imperial, CABuilt 1970 · S/N 28-5484 N3717RHealdsburg Aviation · Healdsburg, CABuilt 1970 · S/N 28-5807 N3718RConklin Loy L · Browns Valley, CABuilt 1970 · S/N 28-5808 N371SAJoshua Leo · Midway, GABuilt 1966 · S/N 28-22550 N3724KTreharne Russell C · Fruita, COBuilt 1967 · S/N 28-23703 N3725RSoutheastern Business Machines Inc · Baxley, GABuilt 1970 · S/N 28-5810 N3730KCloutier Felix S · Fond Du Lac, WIBuilt 1967 · S/N 28-23708 N3736KBloom Cory G · Indianola, IABuilt 1967 · S/N 28-23713 N373BSPenn Mitchell · Poplar Bluff, MOBuilt 1969 · S/N 28-26555 N3747KBelcher Randall Mcarthur II · Lake Havasu City, AZBuilt 1967 · S/N 28-23718 N3750KDalton Bart · Owasso, OKBuilt 1967 · S/N 28-23719 N3756REllington Christopher T · Owenton, KYBuilt 1970 · S/N 28-5814 N3757KSkylux Aviation LLC · Coppell, TXBuilt 1967 · S/N 28-23721 N3763KRyback Andrew · Ocala, FLBuilt 1967 · S/N 28-23722 N3775RBack Mark D · Washington, DCBuilt 1970 · S/N 28-5818 N3781KBomar Tami J · Gig Harbor, WABuilt 1967 · S/N 28-23728 N3782RFreeman William B Jr · Southington, CTBuilt 1970 · S/N 28-5824 N3784KBurr Walter E · Tecumseh, MIBuilt 1967 · S/N 28-23729 N378BPBlue Sky Education Inc · Louisville, KYBuilt 1964 · S/N 28-1547 N3794K10 Skies LLC · Rockport, TXBuilt 1967 · S/N 28-23731 N3798KCrosswind Aviation Of Oklahoma LLC · Stillwater, OKS/N 28-23733 N3799KVea Lynn B · Mokena, ILBuilt 1967 · S/N 28-23734 N379LAM&K Commercial Diving LLC · Fair Haven, VTBuilt 1965 · S/N 28-2418 N37DMWilliams Arzania S · Bolingbrook, ILBuilt 1968 · S/N 28-25245 N37WDRudy Schmitt · Brookshire, TXBuilt 1967 · S/N 28-4550 N3802RN3802r LLC · New Ringgold, PABuilt 1970 · S/N 28-5830 N3804KWebster Max S · Dalton, PABuilt 1967 · S/N 28-23736 N3808RCatalano Joan E · Sequim, WABuilt 1970 · S/N 28-5834 N3811KHendrickson Raymond G · Severn, MDBuilt 1967 · S/N 28-23737 N38147St Denis Robert G · Lake City, FLBuilt 1977 · S/N 28-7725251 N3814RCarlton Kevin · Mount Vernon, WABuilt 1970 · S/N 28-5835 N38190Classic Aviation Inc · Pella, IABuilt 1977 · S/N 28-7725260 N38193Ramirez Katherin · Homestead, FLBuilt 1977 · S/N 28-7725265 N38194Jhl Financial Services Inc · Montgomery, NYS/N 28-7725268 N3820RAnagnos Nick C · East Moline, ILS/N 28-5836 N3821KSoar Above Flight Solutions LLC · Englewood, TNBuilt 1967 · S/N 28-23739 N38312Barnes Carl A · Jacksonville, FLS/N 28-7725261 N38313Lwr LLC · Teton, IDBuilt 1977 · S/N 28-7725262 N38315Meyer Lynn O · Olathe, KSBuilt 1977 · S/N 28-7725275 N3834RK J Aviation LLC · Jasper, INBuilt 1970 · S/N 28-5828 N3836KValarchi Air Aviation LLC · Lewes, DEBuilt 1967 · S/N 28-23743 N3844KSymonds Gregory S · Old Lyme, CTBuilt 1967 · S/N 28-23746 N38477California In Nice Inc · San Jose, CABuilt 1977 · S/N 28-7725282 N38478Pa28 LLC · Sebastian, FLBuilt 1977 · S/N 28-7725283 N38513J&L Aviation LLC · Wilmington, DEBuilt 1977 · S/N 28-7725284 N3851RIriana Arthur · Palmdale, CABuilt 1970 · S/N 28-5840 N3853RDimichele James Jr · Ronkonkoma, NYBuilt 1970 · S/N 28-5844 N38578H & H Contracting And Lease Services Inc · Midlothian, ILBuilt 1977 · S/N 28-7725256

Back to AD 96-10-01 R1