Registered aircraft · 13,646

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:67-22-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:67-22-06') 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:67-22-06')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:67-22-06')
  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:67-22-06')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:67-22-06')
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.

N1001A1st Avenue Ttc LLC · Los Angeles, CAS/N CG3 N1004DGiezen Jurgen J · Fairfax, VAS/N 26001C N100AESale Reported · Spencer, NESale reported, pending cancellationBuilt 1978 · S/N 32R-7985058 N100DDCook Allen J · Aurora, COBuilt 1948 · S/N NAV41518 N100EEConcho Aviation LLC · Sterling City, TXBuilt 2006 · S/N 11028 N100ENRegistration Pending · Downingtown, PARegistration pending, pending cancellationS/N 816 N100JGClub Cherokee Inc · Crystal, MNBuilt 1988 · S/N 3213019 N100JVKremers Gary · Zeeland, MIBuilt 2012 · S/N 40992 N100KYRegistration Pending · Weston, FLRegistration pendingBuilt 1987 · S/N 901 N100LWN100lw LLC · Hickory, NCBuilt 1980 · S/N 32-8006091 N100NYAplustill Keith A · Los Osos, CABuilt 1985 · S/N 24-1526 N100PBDoobie Air LLC · Wilmington, DEBuilt 1978 · S/N 61P05847963257 N100SELanger Paul Hubert · Gainesville, TXBuilt 1971 · S/N RM-1 N100TCMckinney Richard P · Fayeteville, ARBuilt 1973 · S/N 28R-7335370 N100UKFurlow Paul S · Annapolis, MDBuilt 2015 · S/N 41541 N100UVJohn B Bateman · Draper, UTBuilt 2004 · S/N 40.405 N1010EIndian Aire LLC · Water Mill, NYBuilt 2006 · S/N 40382 N1010TReilly Patrick W · Rockford, ILBuilt 2024 · S/N 1107 N1010YGregory Kenneth · Crowley Lake, CABuilt 1970 · S/N 28R-35800 N1011JJames Robert L · East Setauket, NYBuilt 1972 · S/N 11 N1012XSunbeam Air Operations LLC · Wilmington, DEBuilt 1975 · S/N 28R-7535215 N1012YNelson Susan P · Kirkland, WABuilt 2005 · S/N 18281543 N1013XBtm Aero LLC · Mansfield, TXS/N 28R-7535216 N1014BClark Joseph C · Avondale, PABuilt 2025 · S/N 42904 N1014QLawler Thomas O · Lava Hot Springs, IDBuilt 1996 · S/N 23029C N1015CCrabtree Chris R · Mooresville, NCBuilt 2020 · S/N STD-FG-565 N1016NDrln Aviation LLC · Charlotte, NCBuilt 2005 · S/N 18281547 N101AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281181 N101CMKuhns Robert M · Wichita, KSBuilt 1973 · S/N MC-146 N101DMClunan John S · Chocorua, NHBuilt 1975 · S/N 391 N101DRShaheen Louis · Austin, TXBuilt 1978 · S/N 32R-7885181 N101DTCristal Air Inc · Wilmington, DEBuilt 1980 · S/N 1 N101DWInternational Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 32R-7680399 N101GEEastwood Justin · Stow, OHBuilt 2000 · S/N 2389 N101GLAssociated Aircraft LLC · San Diego, CAS/N 0714 N101HHElmhurst Holdings LLC · East Rochester, NYBuilt 1980 · S/N 27-8054057 N101JKKaras Dean · Lansing, KSS/N 28R-7335243 N101JPKrouse Donald E · Weaverville, CABuilt 2002 · S/N 40.218 N101LULynn University Inc · Boca Raton, FLBuilt 1999 · S/N 17280709 N101MGWhatley Danny Wayne · Palmer, AKBuilt 1997 · S/N 0010 N101PRSokol Steven M · Cedar Park, TXBuilt 2001 · S/N 23188 N101TWMiller Colton · Mckinney, TXBuilt 1990 · S/N TMW-1 N101UAReichard David Elijah · Breinigsville, PABuilt 1960 · S/N 23-1950 N101VAJordan Milton S Jr · Carrollton, TXS/N SFD 001 N101VBRegistered aircraftBuilt 1999 · S/N 18280438 N101VKWings Over Texas Holdings LLC · Denton, TXBuilt 1999 · S/N 172S8211 N101VRDunn Thomas A · Fairhope, ALBuilt 1995 · S/N 18023C N101WCole-Tac LLC · Rapid City, SDBuilt 1980 · S/N 32R-8013087 N101WGGard Aviation LLC · Elkhart, IABuilt 2009 · S/N 40697 N1020HHw Barnhouse Inc · Vero Beach, FLBuilt 1968 · S/N 30-1569

Back to AD 67-22-06