AD 94-05-05 R1
Registered aircraft · 26,231
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N5529RCarlson Scott M · Sycamore, ILN5529TCornell James R · Winston Salem, NCN552RAGuzman Jose D · Arecibo, PRN552RYYoreck Robert J Jr · Clarksville, TNN5530RHarris Marilyn L · Hugoton, KSN5531RAbraham Philip L · Amery, WIN5531TLegault Marcus · Frazier Park, CAN5532ETjs Holdings LLC · Dover, OHN5532HStout Walt · White Hills, AZN5532RGreco Anthony · Walworth, WIN55332Reed Matthew A · Burnsville, MNN5533GJaeger Robert G · Lake City, FLN5533HG2g Aeroservices LLC · Medina, OHN5533TChapman Alan T · Cottage Grove, MNN5535RSmh Aeronautics LLC · Woodville, WIN5536CWhite Thomas G · Knoxville, PAN5536HSands Donald R · Yukon, OKN5536RRock Darryl P · Anaheim, CAN5538HDilse Ted D · Scranton, NDN5538RSpringinsguth Wayne R · Bark River, MIN5538T172 Fayette Inc · La Grange, TXN5539HAlexander Steven T · Wasilla, AKN553LFLarocque Daniel J · Anchorage, AKN5540RAbel Justin Edward · Cincinnati, OHN5540VLeroy Philippe G · Willcox, AZN5541ERoundy Steve G · Saint George, UTN5541TYoungstown Flight School Inc · Youngstown, OHN5542CPatterson Phillip L · Knoxville, TNN5543CScott Benge D · Lebanon, ORN5544CSamoilenko Sergey V · Hillsborough, NCN5544RDijon Aviation LLC · Wadsworth, ILN5545CJenkins Alfred G · Bangor, MEN5545GTinkham Dennis T · Leavenworth, KSN5545HGreen Bob · Belgrade, MTN5545RCarlson Michael · Burlington, WYN5546CWeinant Michael W Trustee · Fairbanks, AKN5546TMeigs Craig · Jasper, ALN5547ESissom Patrick · Hillsboro, TNN5547HFisher Garrett L · Sheridan, WYN5547TGoodyear Ron L · Leo, INN5548BManna Farms Inc · Sherwood, NDN5548EPowell Nathan · Columbia Falls, MTN5548RSmietanski Nathan E · Terlton, OKN5549EBacchus Tim · Tucson, AZN5549GFrantz Donna Pratt · Ocala, FLN5550CBendickson Roger · Garrison, NDN5550RMetro Technology Centers · Oklahoma City, OKN5550TCirrus Five LLC · Merritt, NCN5551CAer Kelly LLC · Port Orange, FLN5551TBailey Robert S · Temecula, CA
Back to AD 94-05-05 R1