AD 46-44-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:46-44-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:46-44-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.
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:46-44-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:46-44-01') 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.
N101GRAlshamari Ahmad M · San Mateo, CAN1044GVoelkerding William Michael · Fairbanks, AKN110VSbur David A · Vancouver, WAN110XPlayter Bud W DBA · Gowen, MIN111GZRabinowitz Warren · Ramrod Key, FLN111NZBlackerby Kevin W · Spicewood, TXN1143UOman Lee · Sequim, WAN1147QGraber Quinten R · Brooksville, MSN115JFFields Joseph H · Placerville, CAN120BMVenegas Keila R · Long Grove, ILN120CEStark Rosemary A · Homosassa, FLN120CMLaminar Skies Aviation LLC · Broken Arrow, OKN120CWWebb Charles E · Cleburne, TXN120DCHockman William C · Lebanon Church, VAN120HTJackson Harry A II · Findlay, ILN120JNOlufsen Niels · Lakeway, TXN120JSJohnson Max L Jr · Greenville, SCN120KFWeber Anthony · New Salisbury, INN120LAldrich Justin M · Dallas, ORN120MALynn Jack Bradford · Lanett, ALN120MZBeames Eric G · Palestine, TXN120PGSilver Rock Completions LLC · Wausau, WIN120RWUnruh Ronnie E · Pampa, TXN120TUPaula LLC · Ault, CON120VMaggart Daniel J · Winchester, ILN120VWSouth Platte Flying Club LLC · Kansas City, MON120XLooper Bobby L · Marion, TXN120YBaldwin James C · Fruita, CON1267NGraff Nathan A · Kelso, WAN12XZ140 LLC · Birmingham, ALN138JJWard Gary P · Lincolnton, GAN1408UAircraft Guaranty Corp Trustee · Oklahoma City, OKN140BTThomas Raymond · Deer Park, WAN140CWind Paul K · Chesterfield, MON140CBVintage Aircraft LLC · Gilbert, SCN140CEClawson Duane W · Enon Valley, PAN140CLBennett Bob J · Greenville, WIN140CRWills William J · Cape Coral, FLN140CSIsrael Oscar M · Sinton, TXN140DConant Stephen · Nyssa, ORN140DFBitikofer Brent E · Kansas City, KSN140DTKing Jeremy S · Rainier, WAN140DWMuriithi Peter K · Middle River, MDN140EDThompson Randy L · Anderson, CAN140EWSouthern Aircraft Consultancy Inc Trustee · Casper, WYN140FLittlefield Molly Flanagan · Kent, WAN140GStong Douglas R · Collegeville, PAN140JHOhlin Christian A · Sebastopol, CAN140JTChristianson Alan J · Camas, WAN140JZLawrence John Z · Kingston Springs, TN
Back to AD 46-44-01