OpenAirDocs.org
AD 48-07-01

Registered aircraft · 2,265

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

N101GRAlshamari Ahmad M · San Mateo, CABuilt 1946 · S/N 9749N1044GVoelkerding William Michael · Fairbanks, AKS/N 14403N110VSbur David A · Vancouver, WABuilt 1946 · S/N 8748N110XPlayter Bud W DBA · Gowen, MIBuilt 1946 · S/N 10449N111GZRabinowitz Warren · Ramrod Key, FLS/N 14756N111NZBlackerby Kevin W · Spicewood, TXBuilt 1947 · S/N 12372N1143UOman Lee · Sequim, WAS/N 11652N1147QGraber Quinten R · Brooksville, MSBuilt 1947 · S/N 12785N115JFFields Joseph H · Placerville, CAS/N 13498N120BMVenegas Keila R · Long Grove, ILBuilt 1947 · S/N 13195N120CEStark Rosemary A · Homosassa, FLBuilt 1946 · S/N 11936N120CMLaminar Skies Aviation LLC · Broken Arrow, OKBuilt 1946 · S/N 11903N120CWWebb Charles E · Cleburne, TXBuilt 1946 · S/N 8718N120DCHockman William C · Lebanon Church, VABuilt 1946 · S/N 12036N120HTJackson Harry A II · Findlay, ILBuilt 1947 · S/N 12924N120JNOlufsen Niels · Lakeway, TXBuilt 1947 · S/N 14207N120JSJohnson Max L Jr · Greenville, SCS/N 13137N120KFWeber Anthony · New Salisbury, INBuilt 1947 · S/N 14144N120LAldrich Justin M · Dallas, ORBuilt 1947 · S/N 12858N120MALynn Jack Bradford · Lanett, ALBuilt 1946 · S/N 12012N120MZBeames Eric G · Palestine, TXBuilt 1946 · S/N 9226N120PGSilver Rock Completions LLC · Wausau, WIS/N 11978N120RWUnruh Ronnie E · Pampa, TXBuilt 1946 · S/N 10506N120TUPaula LLC · Ault, COBuilt 1946 · S/N 8934N120VMaggart Daniel J · Winchester, ILBuilt 1946 · S/N 9398N120VWSouth Platte Flying Club LLC · Kansas City, MOBuilt 1947 · S/N 12936N120XLooper Bobby L · Marion, TXBuilt 1948 · S/N 14345N120YBaldwin James C · Fruita, COBuilt 1946 · S/N 9514N1267NGraff Nathan A · Kelso, WAS/N 14298N12XZ140 LLC · Birmingham, ALS/N 13182N138JJWard Gary P · Lincolnton, GABuilt 1946 · S/N 8035N1408UAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1948 · S/N 14989N140BTThomas Raymond · Deer Park, WAS/N 8478N140CWind Paul K · Chesterfield, MOS/N 12501N140CBVintage Aircraft LLC · Gilbert, SCBuilt 1947 · S/N 12994N140CEClawson Duane W · Enon Valley, PAS/N 12928N140CLBennett Bob J · Greenville, WIS/N 11485N140CRWills William J · Cape Coral, FLS/N 9928N140CSIsrael Oscar M · Sinton, TXS/N 14641N140DConant Stephen · Nyssa, ORBuilt 1946 · S/N 8395N140DFBitikofer Brent E · Kansas City, KSS/N 14439N140DTKing Jeremy S · Rainier, WABuilt 1946 · S/N 8006N140DWMuriithi Peter K · Middle River, MDBuilt 1946 · S/N 8143N140EDThompson Randy L · Anderson, CABuilt 1946 · S/N 11148N140EWSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1946 · S/N 9727N140FLittlefield Molly Flanagan · Kent, WABuilt 1946 · S/N 9179N140GStong Douglas R · Collegeville, PABuilt 1946 · S/N 8266N140JHOhlin Christian A · Sebastopol, CABuilt 1946 · S/N 10223N140JTChristianson Alan J · Camas, WAS/N 10711N140JZLawrence John Z · Kingston Springs, TNBuilt 1946 · S/N 11380
Back to AD 48-07-01