Skip to content

Registered aircraft · 68,375

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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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.

N3260KKouri Douglas M · Ray Twp, MIBuilt 1983 · S/N 595 N3260MWalters Don L · Social Circle, GABuilt 1947 · S/N 12-2124 N32610Ambrose Air LLC · Raleigh, NCBuilt 1974 · S/N 28-7515198 N32613Gray Matthew C · Enterprise, ALBuilt 1974 · S/N 28R-7535072 N32618United Towing & Transport Inc · Burbank, CABuilt 1983 · S/N 1120 N32621Simmons Donald W · Dayton, VABuilt 1940 · S/N 5490 N32622Region Flyers LLC · Valparaiso, INBuilt 1974 · S/N 28R-7535073 N32627Joyner Hudson Ellis · Memphis, TNS/N 28-7525091 N3262BRegistered aircraftN-number assigned, not yet registeredS/N 22-2083 N3262FCm&K Enterprises Inc · Brandon, MSBuilt 1967 · S/N 670055 N3263FVelazquez Carlos A · Lexington Park, MDBuilt 1967 · S/N 670056 N3263GMadden Russell · Graford, TXBuilt 1947 · S/N 361 N3263PSalazar Ralph T Jr · Leesville, LABuilt 1965 · S/N 28-2338 N3263ZCaldwell Jacob A · Soldotna, AKBuilt 1960 · S/N 227212 N32646Russell Thomas Carl · Beverly Hills, FLBuilt 1974 · S/N 28-7525094 N32649Pensinger Chris · Saint Paul, MNFirst renewal noticeBuilt 1974 · S/N 28-7515209 N3264FWhite Sawyer A · Longmont, COBuilt 1967 · S/N 670057 N3264TVan Iderstyne Richard D · Jekyll Island, GABuilt 1967 · S/N 17700564 N32653Emerald Flyers LLC · Everett, WABuilt 1974 · S/N 28-7505079 N32659Allen Aviation LLC · Mansfield, MABuilt 1974 · S/N 28-7515212 N3265ETa Brand LLC · Middletown, DEBuilt 1978 · S/N 17271483 N3265FOsborne Allen Wright · Waxhaw, NCBuilt 1967 · S/N 670058 N32660Bendickson Carrie J · Garrison, NDS/N 5521 N32662Murukas Nicholas · Bourbonnais, ILBuilt 1974 · S/N 28-7515213 N32664American Aviation II LLC · Peyton, COS/N 5523 N32665White Richard L Trustee · Los Altos, CABuilt 1974 · S/N 28R-7535076 N3266EN3266e LLC · Homestead, FLBuilt 1978 · S/N 17271484 N3266FStolar Michael · Washington, VABuilt 1967 · S/N 670059 N3266TWiechman Matthew D · Apo, AEBuilt 2008 · S/N 47544 N3267BHilgendorf Ross E · Welcome, MNBuilt 1954 · S/N 22-2088 N32680Neumann Peter G · Cape Coral, FLBuilt 1974 · S/N 28R-7535077 N32684Registration Pending · Brooks, GARegistration pendingBuilt 1974 · S/N 28-7525097 N3268BJohnson Randall A · Anaconda, MTBuilt 1954 · S/N 22-2089 N3268KRegistered aircraftBuilt 1968 · S/N 17700519 N3268POn Glideslope LLC · Middletown, DEFirst renewal noticeBuilt 1957 · S/N 23-1213 N3268TKawsara Sabah M · Fort Worth, TXBuilt 1967 · S/N 17700568 N32690Integrity Aviation LLC · Coatesville, INBuilt 1974 · S/N 28-7515217 N32691Mid-American Pilot Association Inc · Lawrenceville, ILBuilt 1974 · S/N 28-7515218 N32692Holland Walter E Trustee · Casa Grande, AZBuilt 1974 · S/N 28-7505083 N32693Oconner Brian E · Santa Cruz, CAS/N 28R-7535078 N3269MMichael J Schwankl · Wasilla, AKBuilt 1947 · S/N 12-2127 N326ARBowen David R · Brandon, MSBuilt 2006 · S/N 20064C N326CCMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881575 N326DSKendal Flight Corp · Presto, PABuilt 2004 · S/N 40.377 N326KCTatro Christopher A · Madras, ORBuilt 1989 · S/N 2019 N326MGSchlosser Kevin E · Saegertown, PABuilt 2012 · S/N 00326 N326MMHarrington James G · Westport, MABuilt 1973 · S/N 28-7325347 N326NDNational Training I LLC · Wilmington, DEBuilt 2003 · S/N 4496173 N326PCChristensen Darrel W Jr · Soldotna, AKBuilt 1958 · S/N 18-6554 N326RFDevito Todd A · Reno, NVBuilt 1988 · S/N 508

Back to AD 90-04-06 R1