AD 2000-09-06
Registered aircraft · 1,273
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:2000-09-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:2000-09-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:2000-09-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:2000-09-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.
N1048QTaf Aerial Services LLC · Corpus Christi, TXN1048TTrotter Thomas J · Bremerton, WAN1048XLogan Colton Dean · Pagosa Springs, CON1049ZMandan Enterprises LLC · Chester, CTN1050RWatrous Scott A · Warrenton, VAN1051SWhitfield David Michael · Cleveland, GAN1051TOwens Randall C · Houston, TXN1051WAir Services International Leasing LLC · Fort Lauderdale, FLN1051ZDranttel Timothy John · Fuquay Varina, NCN1052TSale Reported · Crystal, MNSale reportedN1052UHuizinga Reinder C · Marietta, GAN1053THenderson State University · Arkadelphia, ARN1054TInternational Air Services Inc Trustee · Carson City, NVN10550Edwards Robert · Daphne, ALN10555Mccrea Daniel B · Waldport, ORN1055CPerry Scott R · Klamath Falls, ORN1055JEmbry William Mark · Gifford, WAN1055TWeiss Martin T · Aquinnah, MAN1055XDcfly LLC. · Bessemer City, NCN1055ZLikovich Robert B Jr · Wake Forest, NCN1058TRock Island Aviation Inc · Wilmington, DEN107AKLazzaro Chris C · Solvang, CAN108FBPlane Fun Inc Tr Trustee · Snellville, GAN108HGKillam Galen Mark · Wautoma, WIN10SYBellany Mark A · Freeville, NYN1101TThompson Thomas Brian · San Francisco, CAN110HSHenderson State University · Arkadelphia, ARN11101Perin Jeffrey S · Wasilla, AKN111KDWedekemper Steven E · Brighton, MIN112CPBradley Aviation LLC · Columbus, INN112LCJacobsen Jeffrey M · Salinas, CAN114HSHenderson State University · Arkadelphia, ARN114MKGood Thomas Ryan · Grapevine, TXN114WMMaule Flight LLC · Nashville, INN116GRegistration Pending · Sheridan, WYRegistration pendingN118GSparks Brian E · Monmouth, ORN11UGBrandemuehl Joseph J · Boscobel, WIN11ZARanch Aero LLC · Sterling City, TXN11ZVWebb Group Flp · Jackson, MSN12008Dvoracek Dana J · Charlevoix, MIN12009Jordan Ronald W · Stoutsville, OHN12011Marsh John Edward · Washington, DCN12014Thompson Robert J · Kaktovik, AKN12015Thurmond Paul J · Huntley, MTN12016Swain Michael J · Jacksonville, FLN12017Nuckles Charles Austin Jr · Suffolk, VAN12018Theriot Harris J Jr · Thibodaux, LAN12026Bernhardt Michael J · North Branch, MNN12027Rugland Roger E · Anoka, MNN12029Dippold Lois M · Perry, MI
Back to AD 2000-09-06