AD 82-06-11 R1
Registered aircraft · 2,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
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:82-06-11-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:82-06-11-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:82-06-11-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:82-06-11-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.
N43793Casanova LLC · The Plains, VAN43794Ochoa Luis M · Hollywood, FLN43798Susong Charles W · Afton, TNN43817Fraser Roger Douglas · Amelia Island, FLN4382XN4382x LLC · Tewksbury, MAN43848White David W · New River, AZN4389XRrg Software LLC · Alpine, CAFirst renewal noticeN4393TJackson R Allen · Granbury, TXN4393XGriffin David R · Amarillo, TXN43966Sims Kenneth Leon · Desert Hot Springs, CAN43967Jo Air Inc · La Mesa, CAN43970Arrow N43970 LLC · Derry, NHN43994Harrison Shawn · Salisbury, MDN43WGMaxfield Kenneth B Trustee · Murray, UTN4401TMcelroy Shawn · East Falmouth, MAN4406TPollard John R · Melbourne, FLN44104Reed Matthew · Lander, WYN44140Helmandollar Steven W · Elkhorn, NEN4414TRegistration Pending · Rockford, MIRegistration pendingN44157Gregoire Alexandra Jennifer · Orlando, FLN441CKWinters John H · Birch Run, MIN44229Cabelka Jerry L · Glendale, AZN4422XKeys Andrew S · Harvest, ALN4424TKoplin Adam · Big Stone City, SDN44254Bridges D Scott · Paducah, KYN4428TGauvin Daniel G · Newport, VTN4428XLeopold Nathan · Fond Du Lac, WIN442GBas Part Sales LLC · Greeley, CON44327Big Duke Aviation LLC · Oshkosh, WIN4434XLusher Frank W II · Prichard, WVN4437SVenture West LLC · Mesa, AZN4437WVenture West LLC · Mesa, AZN44388Zavoda Scott E · Strongsville, OHN4438DMa Aviation LLC · Danville, ILN4439XMccormick Robert E · Yakima, WAN4443XFox Two LLC · Camino, CAN44443Jax Navy Flying Club · Jacksonville, FLN44458Forsman Airways LLC · Glenwood, MNN444DPStratospheric Ventures LLC · Saint Petersburg, FLN444HPCrosswind Aviation Inc · Oakley, KSN444JSIndigo Of South Fl Inc · Sunrise, FLN444SLD And E Consulting LLC · Taylor, ARN44521Silker Services LLC · Schaumburg, ILN4452TUtehin Nick A · San Mateo, CAN4452XAlpha Dairy Chi LLC · Locust Grove, OKN4455MClear Prop LLC · Roswell, GAN4456XFly By Knight Corp · Shoreview, MNN44572Hornet Aviation Inc · Tallahassee, FLN4461TRobinson Joseph B · Washington, DCN4461XHaggerty James D · Scott Depot, WV
Back to AD 82-06-11 R1